{"id":486,"date":"2015-05-19T09:40:31","date_gmt":"2015-05-19T01:40:31","guid":{"rendered":"http:\/\/www.llku.com\/?p=486"},"modified":"2015-05-19T11:04:41","modified_gmt":"2015-05-19T03:04:41","slug":"%e8%b5%84%e4%ba%a7%e4%ba%8b%e5%8a%a1%e5%a4%84%e7%90%86%e8%bf%87%e7%a8%8bsql","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=486","title":{"rendered":"\u8d44\u4ea7\u4e8b\u52a1\u5904\u7406\u8fc7\u7a0bSQL"},"content":{"rendered":"

\n\tSELECT FL.DESCRIPTION              \u4e8b\u52a1\u5904\u7406\u63cf\u8ff0,
\n\t       FT.TRANSACTION_TYPE_CODE    \u4e8b\u52a1\u5904\u7406\u4ee3\u7801,
\n\t       FT.TRANSACTION_DATE_ENTERED \u4e8b\u52a1\u5904\u7406\u65f6\u95f4,
\n\t       FAA.ASSET_NUMBER            \u8d44\u4ea7\u7f16\u53f7,
\n\t       FB.ORIGINAL_COST            \u8d44\u4ea7\u539f\u503c,
\n\t       FFV.DESCRIPTION             \u673a\u6784,
\n\t       FAT.DESCRIPTION             \u8d44\u4ea7\u8bf4\u660e\n<\/p>\n

\n\t  FROM FA_TRANSACTION_HEADERS  FT,
\n\t       FA_LOOKUPS_VL           FL,
\n\t       FA_ADDITIONS_B          FAA,
\n\t       FA_ADDITIONS_TL         FAT,
\n\t       FA_BOOKS_V              FB,
\n\t       FA_DISTRIBUTION_HISTORY FD,
\n\t       GL_CODE_COMBINATIONS    GCC,
\n\t       FND_FLEX_VALUES_VL      FFV,
\n\t       FND_FLEX_VALUE_SETS     FFVS
\n\t WHERE 1 = 1
\n\t   AND FAA.ASSET_ID = FT.ASSET_ID
\n\t   AND FAT.ASSET_ID = FAA.ASSET_ID
\n\t   AND FB.ASSET_ID = FAA.ASSET_ID
\n\t   AND FD.ASSET_ID = FB.ASSET_ID
\n\t   AND FL.LOOKUP_CODE = FT.TRANSACTION_TYPE_CODE
\n\t   AND FL.LOOKUP_TYPE = 'FAXOLTRX'
\n\t   AND (FFV.END_DATE_ACTIVE IS NULL OR FFV.END_DATE_ACTIVE > SYSDATE)
\n\t   AND FFV.ENABLED_FLAG = 'Y'
\n\t   AND FFV.FLEX_VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID
\n\t   AND FFVS.FLEX_VALUE_SET_NAME = 'XXXX_COMPANY' –COA\u673a\u6784\u6bb5
\n\t   AND GCC.CODE_COMBINATION_ID = FD.CODE_COMBINATION_ID
\n\t   AND GCC.SEGMENT1 = FFV.FLEX_VALUE
\n\t— AND TO_CHAR(FT.TRANSACTION_DATE_ENTERED, 'YYYY-MM-DD') BETWEEN
\n\t—    '2014-12-31' AND '2014-12-31'
\n\t–AND FT.TRANSACTION_TYPE_CODE = 'ADDITION'
\n\t ORDER BY FFV.FLEX_VALUE, FT.TRANSACTION_DATE_ENTERED ASC;<\/p>\n","protected":false},"excerpt":{"rendered":"

SELECT FL.DESCRIPTION     &nbs … \u7ee7\u7eed\u9605\u8bfb\u8d44\u4ea7\u4e8b\u52a1\u5904\u7406\u8fc7\u7a0bSQL<\/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":[7],"tags":[90],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/486"}],"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=486"}],"version-history":[{"count":2,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/486\/revisions"}],"predecessor-version":[{"id":491,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/486\/revisions\/491"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}