Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\ja\TDPAX\td_bldemprpts.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ja" lang="ja"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>??????????????????????????????</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:17:40Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Linking the Employees and Departments Reports" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11946-01" /> <link rel="copyright" href="../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="../dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface.htm" title="Home" type="text/html" /> <link rel="up" href="build_app.htm" title="Building Your Application" type="text/html" /> <link rel="up" href="td_bldemprpts.htm" title="Linking the Employees and D..." type="text/html" /> <link rel="prev" href="td_bldlink.htm" title="Previous" type="text/html" /> <link rel="next" href="td_bldcolval.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="?????">?????</a> > <a href="build_app.htm" title="?????????????????"> ?????????????????</a> > ??????????????????????????????</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="td_bldlink.htm"><img src="../dcommon/gifs/leftnav.gif" alt="???" /><br /><span class="icon">???</span></a> </td> <td align="center"><a href="td_bldcolval.htm"><img src="../dcommon/gifs/rightnav.gif" alt="?°?" /><br /><span class="icon">?°?</span></a></td> </tr> </table> <p><a id="BCECEDHD" name="BCECEDHD"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1><a name="TDPAX04009|how to link the Employees and Departments report"></a><a id="sthref242" name="sthref242"></a><a id="sthref243" name="sthref243"></a><a id="sthref244" name="sthref244"></a>??????????????????????????????</h1> <p>??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????</p> <a id="sthref245" name="sthref245"></a> <p class="subhead2">??????:</p> <ul> <li> <p><a href="#BCECEFCH">????????????</a></p> </li> <li> <p><a href="#BCEJJIDC">???????????</a></p> </li> <li> <p><a href="#BCEBGAJB">????????????????????</a></p> </li> <li> <p><a href="#BCEGIHBA">???????????</a></p> </li> </ul> <a id="BCECEFCH" name="BCECEFCH"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h2><a id="sthref246" name="sthref246"></a><a id="sthref247" name="sthref247"></a><a id="sthref248" name="sthref248"></a>????????????</h2> <p>????????????????????????????????????????????????????????</p> <p>??????????????????????????????????</p> <ol> <li> <p>3??????????°?????????????????????????????</p> </li> <li> <p>??????????????????????<span class="bold">???????</span>????????????????????</p> </li> <li> <p>????????????????????????????</p> <ol> <li> <p>?????????????????????????????????: ?????????<span class="bold">??TML??</span>?????????<span class="bold">???????</span>??????????????</p> </li> <li> <p>??????HTML??????????????????????????: ?????????<span class="bold">??TML??</span>?????????<span class="bold">???????</span>??????????????</p> </li> </ol> </li> <li> <p>???????????????????????????</p> <ol> <li> <p>??????: <code>Department</code>???????????</p> </li> <li> <p>??????????????????: <span class="bold">No Template</span>???????????</p> <p>???????????????????????????<span class="italic">???</span>????????????????????</p> </li> <li> <p>???: <code>5</code>????????????????????????????????????????????</p> </li> <li> <p>???????????????????????<span class="bold">???????</span>??????????????</p> </li> </ol> </li> <li> <p><span class="bold">????????????????</span>??????????????</p> <p>?????????????????????HTML?????????????????????????????????</p> <img src="img/reg_sect_depthtml.gif" alt="??eg_sect_depthtml.gif????????????" title="??eg_sect_depthtml.gif????????????" longdesc="img_text/reg_sect_depthtml.htm" /><br /> <a id="sthref249" name="sthref249" href="img_text/reg_sect_depthtml.htm">??eg_sect_depthtml.gif?????</a><br /> <br /></li> </ol> </div> <!-- class="sect2" --> <a id="BCEJJIDC" name="BCEJJIDC"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h2><a id="sthref250" name="sthref250"></a><a id="sthref251" name="sthref251"></a><a id="sthref252" name="sthref252"></a>???????????</h2> <p>?°????????????????????????????????????????????OV????????????????????</p> <p>?°?????????????????????????</p> <ol> <li> <p>?????????????<span class="bold">???????</span>????????????????????</p> </li> <li> <p>???????????????????????????????</p> <ol> <li> <p>?????????????????: <span class="bold">???????????</span>????????<span class="bold">???????</span>??????????????</p> </li> <li> <p>???????°?????????: <span class="bold">?????????????????????</span>????????<span class="bold">???????</span>??????????????</p> <p>??????????????????????????????????????????????????????????????</p> </li> </ol> </li> <li> <p>????????????????????????????????????</p> <ol> <li> <p>????????: <code>P3_DEPARTMENT_ID</code>???????????</p> </li> <li> <p>???: ?????????<span class="bold">10</span>?????????????</p> </li> <li> <p>????????: <span class="bold">?????1??5</span>???????????</p> </li> <li> <p><span class="bold">???????</span>??????????????</p> </li> </ol> </li> <li> <p>??OV?????????????????</p> <ol> <li> <p><a id="sthref253" name="sthref253"></a>??????LOV: <span class="bold">DEPARTMENTS</span>???????????</p> <p>????????????????????????????????????????????????????????????????????????????????</p> </li> <li> <p><a id="sthref254" name="sthref254"></a>NULL????????????: ?????????<span class="bold">???????</span>?????????????</p> </li> <li> <p><a id="sthref255" name="sthref255"></a>NULL??????: ?°???????????</p> <pre xml:space="preserve" class="oac_no_warn"> - No Department Assigned - </pre></li> <li> <p><a id="sthref256" name="sthref256"></a>NULL??: ?°???????????</p> <pre xml:space="preserve" class="oac_no_warn"> -1 </pre> <p>NULL??????????????????????????????????????????????????????????????????????????<span class="bold">????????????????????????</span>????????????????????????????????????????????-1?????????????????????????????????????</p> </li> <li> <p><span class="bold">???????</span>??????????????</p> </li> </ol> </li> <li> <p>????????????????????<code>Department</code>????????<span class="bold">???????</span>??????????????</p> </li> <li> <p>????????????????????????????</p> <ol> <li> <p>????????: <code>-1</code>???????????</p> </li> <li> <p>??????????????????????????</p> </li> <li> <p><span class="bold">??????????????</span>??????????????</p> </li> </ol> </li> </ol> </div> <!-- class="sect2" --> <a id="BCEBGAJB" name="BCEBGAJB"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h2>????????<a id="sthref257" name="sthref257"></a><a id="sthref258" name="sthref258"></a><a id="sthref259" name="sthref259"></a><a id="sthref260" name="sthref260"></a>????????????</h2> <p>?????????????????????????????????????????????????????????????????????????????????????????????<code>WHERE</code>??????????????????????</p> <p>??????????????????????????????????????????????</p> <ol> <li> <p>????????????????????????????<span class="bold">????????</span>???????????????????</p> </li> <li> <p>?????????????????????????</p> </li> <li> <p>??????????????????????????????????°?????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> WHERE (DEPARTMENT_ID = :P3_DEPARTMENT_ID or (DEPARTMENT_ID is null and nvl(:P3_DEPARTMENT_ID,'1') = '-1')) </pre> <p>???<code>WHERE</code>????????????????????????????????????????????????????????????</p> </li> <li> <p><span class="bold">???????????</span>??????????????</p> </li> </ol> </div> <!-- class="sect2" --> <a id="BCEGIHBA" name="BCEGIHBA"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h2><a id="sthref261" name="sthref261"></a><a id="sthref262" name="sthref262"></a><a id="sthref263" name="sthref263"></a>???????????</h2> <p>??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????</p> <p>???????????????????????????????????????</p> <ol> <li> <p>???????????????????????????????<span class="bold">???????</span>????????????????????</p> <img src="img/pgproc_branch.gif" alt="??gproc_branch.gif????????????" title="??gproc_branch.gif????????????" longdesc="img_text/pgproc_branch.htm" /><br /><a id="sthref264" name="sthref264" href="img_text/pgproc_branch.htm">??gproc_branch.gif?????</a><br /><br /></li> <li> <p>????????????????????????????????????????<span class="bold">???????</span>??????????????</p> </li> <li> <p>?????????????°???????????</p> <ol> <li> <p>?????: <code>3</code>???????????</p> </li> <li> <p><span class="bold">???????????????????????????)??</span>?????????????????????????</p> <p>???????????????????????????????????????????????????????????????????????????????????????????????????????????3?????????????????????????????????????????????3???????????????????</p> </li> <li> <p><span class="bold">???????</span>??????????????</p> </li> </ol> </li> <li> <p><span class="bold">??????????????</span>??????????????</p> </li> <li> <p>????????????????</p> </li> <li> <p>????????????????<span class="bold">??ccounting??</span>???????????</p> <p>???????????????????????????????????????????????????????</p> <img src="img/bldap_deptfilter.gif" alt="??ldap_deptfilter.gif????????????" title="??ldap_deptfilter.gif????????????" longdesc="img_text/bldap_deptfilter.htm" /><br /><a id="sthref265" name="sthref265" href="img_text/bldap_deptfilter.htm">??ldap_deptfilter.gif?????</a><br /><br /></li> </ol> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright (C) 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="../dcommon/html/cpyr.htm"> <span class="copyrightlogo">???????????</span></a></td> <td align="center"><a href="td_bldlink.htm"><img src="../dcommon/gifs/leftnav.gif" alt="???" /><br /><span class="icon">???</span></a> </td> <td align="center"><a href="td_bldcolval.htm"><img src="../dcommon/gifs/rightnav.gif" alt="?°?" /><br /><span class="icon">?°?</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de