{"id":516,"date":"2015-06-17T10:49:27","date_gmt":"2015-06-17T02:49:27","guid":{"rendered":"http:\/\/www.llku.com\/?p=516"},"modified":"2016-04-20T21:46:37","modified_gmt":"2016-04-20T13:46:37","slug":"%e8%8e%b7%e5%8f%96%e9%93%b6%e8%a1%8c%e5%88%86%e8%a1%8c%e6%89%80%e5%9c%a8%e7%9a%84%e7%9c%81%e4%bb%bd%e5%92%8c%e5%9f%8e%e5%b8%82%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=516","title":{"rendered":"\u83b7\u53d6\u94f6\u884c\u5206\u884c\u6240\u5728\u7684\u7701\u3001\u5e02\u4fe1\u606f"},"content":{"rendered":"

\n\t \u4e4b\u524d\u5728\u505a\u4e00\u4e2a\u94f6\u884c\u62bd\u76d8\u6587\u4ef6\u7684\u65f6\u5019\uff0c\u9700\u8981\u83b7\u53d6\u5230\u4f9b\u5e94\u5546\u5bf9\u5e94\u7ef4\u62a4\u7684\u94f6\u884c\u5206\u884c\u6240\u5728\u7684\u7701\u5e02\u4fe1\u606f\uff0c\u4e8e\u662f\u8bb0\u5f55\u4e0b\u83b7\u53d6\u7684sql\u547d\u4ee4\uff0c\u5982\u4e0b\uff1a\n<\/p>\n

\n\t \u8bb0\u5f55\u94f6\u884c\u4fe1\u606f\u7684\u754c\u9762\uff1a\n<\/p>\n

\n\t $\"\u6765\u6e90\u754c\u9762\"$ <\/a>\n<\/p>\n

\n\t–\u94f6\u884c\u5206\u884c\u7684\u5730\u5740\u884c1\u548c\u57ce\u5e02\u6570\u636e
\n\tSELECT HP.ADDRESS1, HP.CITY
\n\t FROM AP_SUPPLIERS            ASP,
\n\t       IBY_EXT_BANK_ACCOUNTS_V IEB,
\n\t       IBY_EXTERNAL_PAYEES_ALL IEP,
\n\t       IBY_PMT_INSTR_USES_ALL USES,
\n\t       IBY_ACCOUNT_OWNERS      IAO,
\n\t       AP_SUPPLIER_SITES_ALL   ASS,
\n\t       HZ_PARTIES              HP
\n\t WHERE 1 = 1
\n\t   AND HP.PARTY_ID = IEB.branch_party_id
\n\t   AND IEP.EXT_PAYEE_ID = USES.EXT_PMT_PARTY_ID
\n\t   AND IEP.PAYMENT_FUNCTION = 'PAYABLES_DISB'
\n\t   AND USES.INSTRUMENT_ID = IEB.EXT_BANK_ACCOUNT_ID
\n\t   AND IEP.PAYEE_PARTY_ID = ASP.PARTY_ID
\n\t   AND ASP.ENABLED_FLAG = 'Y'
\n\t   AND ASP.SUMMARY_FLAG = 'N'
\n\t   AND IEP.PARTY_SITE_ID IS NULL
\n\t   AND IEP.SUPPLIER_SITE_ID IS NULL
\n\t   AND IEP.ORG_ID IS NULL
\n\t   AND (USES.END_DATE IS NULL OR USES.END_DATE > SYSDATE)
\n\t   AND (IEB.END_DATE IS NULL OR IEB.END_DATE > SYSDATE)
\n\t   AND (ASP.END_DATE_ACTIVE IS NULL OR ASP.END_DATE_ACTIVE > SYSDATE)
\n\t   AND (ASS.INACTIVE_DATE IS NULL OR ASS.INACTIVE_DATE > SYSDATE)
\n\t   AND ASS.VENDOR_ID = ASP.VENDOR_ID
\n\t   AND USES.INSTRUMENT_TYPE = 'BANKACCOUNT'
\n\t   AND IAO.ACCOUNT_OWNER_PARTY_ID = ASP.PARTY_ID
\n\t   AND IAO.EXT_BANK_ACCOUNT_ID(+) = IEB.ext_bank_account_id
\n\t   –AND IEB.BANK_ACCOUNT_ID = P_BANK_ACC_ID –\u94f6\u884cID
\n\t   –AND ASP.VENDOR_ID = P_VENDOR_ID         –\u4f9b\u5e94\u5546ID
\n\t   –AND ASS.VENDOR_SITE_ID = P_VENDOR_SITE_ID –\u4f9b\u5e94\u5546\u5730\u70b9ID
\n\t ORDER BY ASP.VENDOR_TYPE_LOOKUP_CODE;<\/p>\n","protected":false},"excerpt":{"rendered":"