{"id":867,"date":"2016-08-05T14:06:06","date_gmt":"2016-08-05T06:06:06","guid":{"rendered":"http:\/\/www.oracle.name\/?p=867"},"modified":"2016-08-05T14:10:14","modified_gmt":"2016-08-05T06:10:14","slug":"ebs%e5%ae%a2%e6%88%b7%e7%9b%b8%e5%85%b3%e4%bf%a1%e6%81%af%e6%9f%a5%e8%af%a2","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=867","title":{"rendered":"EBS\u5ba2\u6237\u76f8\u5173\u4fe1\u606f\u67e5\u8be2"},"content":{"rendered":"<p>\n\tSELECT hou.name \u4e1a\u52a1\u5b9e\u4f53,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hp.party_name \u5ba2\u6237\u540d\u79f0,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hca.account_number \u5ba2\u6237\u7f16\u53f7,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hp.tax_reference \u7eb3\u7a0e\u7f16\u53f7,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hca.attribute1 \u5ba2\u6237\u96c6\u56e2,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa.status \u6709\u6548\u5426,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; to_char(bb.creation_date, &#39;YYYY-MM-DD&#39;) \u521b\u5efa\u65e5\u671f,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bb.bill_to_flag \u6536\u5355\u6807\u793a,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bb.ship_to_flag \u6536\u8d27\u6807\u793a,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cc.country \u56fd\u5bb6,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cc.address1 \u5730\u70b9\u540d\u79f0,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dd.site_use_id \u5730\u70b9\u7f16\u53f7,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dd.site_use_code,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dd.primary_flag,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dd.status,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dd.location \u4e1a\u52a1\u76ee\u7684\u7f16\u53f7,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dd.bill_to_site_use_id \u6536\u5355\u5730id,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rt.name \u4ed8\u6b3e\u6761\u4ef6,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gcc.concatenated_segments \u5e94\u6536\u79d1\u76ee,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gcc01.concatenated_segments \u6536\u5165\u79d1\u76ee,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dd.tax_code \u7a0e\u7801,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SELECT res.resource_name<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM jtf_rs_salesreps sr, jtf_rs_resource_extns_vl res<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE sr.resource_id = res.resource_id<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND sr.org_id = dd.org_id<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND sr.salesrep_id = dd.primary_salesrep_id) \u9500\u552e\u5458<br \/>\n\t&nbsp; FROM hz_parties&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hp,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hz_party_sites&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hz_cust_acct_sites_all&nbsp;&nbsp; bb,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hz_locations&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cc,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hz_cust_site_uses_all&nbsp;&nbsp;&nbsp; dd,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hr_operating_units&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hou,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ra_terms_vl&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rt,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hz_cust_accounts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hca,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gl_code_combinations_kfv gcc,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gl_code_combinations_kfv gcc01<br \/>\n\t&nbsp;WHERE aa.party_site_id = bb.party_site_id<br \/>\n\t&nbsp;&nbsp; AND hca.party_id = hp.party_id<br \/>\n\t&nbsp;&nbsp; AND aa.status = &#39;A&#39;<br \/>\n\t&nbsp;&nbsp; AND rt.term_id = dd.payment_term_id<br \/>\n\t&nbsp;&nbsp; AND hou.organization_id = bb.org_id<br \/>\n\t&nbsp;&nbsp; AND hp.party_id = aa.party_id<br \/>\n\t&nbsp;&nbsp; AND aa.location_id = cc.location_id<br \/>\n\t&nbsp;&nbsp; AND bb.cust_acct_site_id(+) = dd.cust_acct_site_id<br \/>\n\t&nbsp;&nbsp; AND dd.status &lt;&gt; &#39;I&#39;<br \/>\n\t&nbsp;&nbsp; AND gcc.code_combination_id(+) = dd.gl_id_rec<br \/>\n\t&nbsp;&nbsp; AND gcc01.code_combination_id(+) = dd.gl_id_rev<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;AND hou.name = &#39;OU&#39;<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u6761\u4ef61\uff1a\u5ba2\u6237\u5bf9\u5e94\u7684OU\uff0c\u9009\u62e9\u76ee\u6807OU<br \/>\n\t&nbsp;&nbsp; AND to_char(bb.creation_date, &#39;yyyy-mm-dd&#39;) &gt;= &#39;2000-01-01&#39;<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u6761\u4ef62\uff1a\u4f9b\u5e94\u5546\u521b\u5efa\u5bf9\u5e94\u7684\u8d77\u59cb\u65e5\u671f\uff0c\u9009\u62e9\u521b\u5efa\u65e5\u671f\u8303\u56f4\uff0c\u5982\u4e0d\u9700\u9650\u5236\uff0c\u8bf7\u6ce8\u91ca\u8be5\u6761\u4ef6<br \/>\n\t&nbsp;&#8212;&nbsp; AND to_char(bb.creation_date, &#39;yyyy-mm-dd&#39;) &lt;= &#39;2015-12-08&#39;<br \/>\n\t&#8211;\u6761\u4ef62\uff1a\u4f9b\u5e94\u5546\u521b\u5efa\u5bf9\u5e94\u7684\u622a\u6b62\u65e5\u671f\uff0c\u9009\u62e9\u521b\u5efa\u65e5\u671f\u8303\u56f4\uff0c\u5982\u4e0d\u9700\u9650\u5236\uff0c\u8bf7\u6ce8\u91ca\u8be5\u6761\u4ef6<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT hou.name \u4e1a\u52a1\u5b9e\u4f53, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#038;nb &hellip; <a href=\"https:\/\/www.llku.com\/?p=867\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">EBS\u5ba2\u6237\u76f8\u5173\u4fe1\u606f\u67e5\u8be2<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[30,128],"tags":[127],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/867"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=867"}],"version-history":[{"count":1,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/867\/revisions"}],"predecessor-version":[{"id":868,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/867\/revisions\/868"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=867"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=867"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}