{"id":51,"date":"2015-01-12T22:49:44","date_gmt":"2015-01-12T14:49:44","guid":{"rendered":"http:\/\/www.llku.com\/llku\/?p=51"},"modified":"2015-01-13T08:52:39","modified_gmt":"2015-01-13T00:52:39","slug":"%e8%8e%b7%e5%8f%96%e4%be%9b%e5%ba%94%e5%95%86%e7%9b%b8%e5%85%b3%e4%bf%a1%e6%81%afsql","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=51","title":{"rendered":"\u83b7\u53d6\u4f9b\u5e94\u5546\u76f8\u5173\u4fe1\u606fSQL"},"content":{"rendered":"

\n\tSELECT ASP.VENDOR_ID AS \u4f9b\u5e94\u5546ID,
\n\t       ASP.VENDOR_NAME AS \u4f9b\u5e94\u5546\u540d\u79f0,
\n\t       ASP.SEGMENT1 AS \u4f9b\u5e94\u5546\u7f16\u53f7,
\n\t       DECODE(ASP.VENDOR_TYPE_LOOKUP_CODE,
\n\t              'EMPLOYEE',
\n\t              '\u5458\u5de5\u4f9b\u5e94\u5546',
\n\t              '\u5916\u90e8\u4f9b\u5e94\u5546') AS \u4f9b\u5e94\u5546\u7c7b\u578b,
\n\t       IEB.BANK_NAME AS \u94f6\u884c,
\n\t       IEB.BANK_BRANCH_NAME AS \u5206\u884c,
\n\t       IEB.BRANCH_PARTY_ID,
\n\t       IEB.BANK_ACCOUNT_NUMBER AS \u94f6\u884c\u8d26\u6237,
\n\t       (SELECT T.DESCRIPTION
\n\t          FROM FND_FLEX_VALUES_VL T, FND_FLEX_VALUE_SETS S
\n\t         WHERE 1 = 1
\n\t           AND T.FLEX_VALUE_SET_ID = S.FLEX_VALUE_SET_ID
\n\t           AND S.FLEX_VALUE_SET_NAME LIKE '%COMPANY'
\n\t           AND T.FLEX_VALUE =
\n\t               (SELECT SUBSTR(HOU.SHORT_CODE, 1, 6)
\n\t                  FROM HR_OPERATING_UNITS HOU
\n\t                 WHERE HOU.ORGANIZATION_ID = ASS.ORG_ID)
\n\t           AND T.ENABLED_FLAG = 'Y'
\n\t           AND SYSDATE < NVL(T.END_DATE_ACTIVE, SYSDATE + 1)) AS \u4e1a\u52a1\u5b9e\u4f53\u540d\u79f0,
\n\t       GCC.SEGMENT3 \u9884\u4ed8\u6b3e\u4f1a\u8ba1\u79d1\u76ee,
\n\t       GCC1.SEGMENT3 \u8d1f\u503a\u4f1a\u8ba1\u79d1\u76ee
\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       GL_CODE_COMBINATIONS_KFV GCC,
\n\t       GL_CODE_COMBINATIONS_KFV GCC1
\n\t WHERE 1 = 1
\n\t   AND IEP.EXT_PAYEE_ID = USES.EXT_PMT_PARTY_ID
\n\t   AND GCC.CODE_COMBINATION_ID = ASS.PREPAY_CODE_COMBINATION_ID
\n\t   AND GCC1.CODE_COMBINATION_ID = ASS.ACCTS_PAY_CODE_COMBINATION_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 (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 ORDER BY ASP.VENDOR_TYPE_LOOKUP_CODE;<\/p>\n","protected":false},"excerpt":{"rendered":"

SELECT ASP.VENDOR_ID AS \u4f9b\u5e94\u5546ID,       &nb … \u7ee7\u7eed\u9605\u8bfb\u83b7\u53d6\u4f9b\u5e94\u5546\u76f8\u5173\u4fe1\u606fSQL<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/51"}],"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=51"}],"version-history":[{"count":3,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/51\/revisions"}],"predecessor-version":[{"id":72,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/51\/revisions\/72"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=51"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=51"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=51"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}