{"id":632,"date":"2016-01-14T11:26:40","date_gmt":"2016-01-14T03:26:40","guid":{"rendered":"http:\/\/www.llku.com\/?p=632"},"modified":"2016-01-14T11:26:40","modified_gmt":"2016-01-14T03:26:40","slug":"%e5%a4%96%e9%83%a8%e5%ae%a1%e8%ae%a1%e6%95%b0%e6%8d%ae%e6%8f%90%e5%8f%96%e5%91%bd%e4%bb%a4","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=632","title":{"rendered":"\u5916\u90e8\u5ba1\u8ba1\u6570\u636e\u63d0\u53d6\u547d\u4ee4"},"content":{"rendered":"

\n\tSELECT FFV1.DESCRIPTION \u673a\u6784\u540d\u79f0,
\n\t       GCC.SEGMENT3 "\u79d1\u76ee\u4ee3\u7801",
\n\t       FFV3.DESCRIPTION \u79d1\u76ee\u540d\u79f0,
\n\t       FU.USER_NAME \u51ed\u8bc1\u5f55\u5165\u4eba,
\n\t       GJS.USER_JE_SOURCE_NAME \u65e5\u8bb0\u8d26\u6765\u6e90,
\n\t       GJC.USER_JE_CATEGORY_NAME \u65e5\u8bb0\u8d26\u7c7b\u522b,
\n\t       GJH.PERIOD_NAME \u4f1a\u8ba1\u671f\u95f4,
\n\t       GJH.POSTED_DATE \u8fc7\u8d26\u65e5\u671f,
\n\t       GJH.EXTERNAL_REFERENCE \u51ed\u8bc1\u53f7\u7801,
\n\t       GJL.DESCRIPTION \u6458\u8981,
\n\t       GJL.ENTERED_DR \u501f\u65b9,
\n\t       GJL.ENTERED_CR \u8d37\u65b9,
\n\t       '' \u65b9\u5411,
\n\t       '' \u4f59\u989d,
\n\t       '' \u5916\u5e01\u4ee3\u7801,
\n\t       '' \u5916\u5e01\u501f\u65b9,
\n\t       '' \u5916\u5e01\u8d37\u65b9\n<\/p>\n

\n\t  FROM GL_JE_HEADERS        GJH,
\n\t       GL_JE_LINES          GJL,
\n\t       GL_CODE_COMBINATIONS GCC,
\n\t       GL_JE_CATEGORIES     GJC,
\n\t       GL_JE_SOURCES        GJS,
\n\t       FND_USER             FU,
\n\t       FND_FLEX_VALUE_SETS  FFVS1,
\n\t       FND_FLEX_VALUES_VL   FFV1,
\n\t       FND_FLEX_VALUE_SETS  FFVS3,
\n\t       FND_FLEX_VALUES_VL   FFV3
\n\t WHERE GJH.JE_HEADER_ID = GJL.JE_HEADER_ID
\n\t   AND GJS.JE_SOURCE_NAME = GJH.JE_SOURCE
\n\t   AND GJC.JE_CATEGORY_NAME = GJH.JE_CATEGORY
\n\t   AND GJL.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
\n\t   AND GJH.CREATED_BY = FU.USER_ID(+)
\n\t   AND GCC.SEGMENT1 = FFV1.FLEX_VALUE
\n\t   AND FFVS1.FLEX_VALUE_SET_ID = FFV1.FLEX_VALUE_SET_ID
\n\t   AND FFVS1.FLEX_VALUE_SET_NAME = 'XXXX_COMPANY' –\u7b2c\u4e00\u6bb5\uff0c\u6839\u636e\u81ea\u5df1\u73af\u5883\u786e\u5b9a
\n\t   AND GCC.SEGMENT3 = FFV3.FLEX_VALUE
\n\t   AND FFVS3.FLEX_VALUE_SET_ID = FFV3.FLEX_VALUE_SET_ID
\n\t   AND FFVS3.FLEX_VALUE_SET_NAME = 'XXXX_ACCOUNT' –\u7b2c\u4e09\u6bb5\uff0c\u6839\u636e\u81ea\u5df1\u73af\u5883\u786e\u5b9a
\n\t   AND GJH.STATUS = 'P'
\n\t   AND GJH.ACTUAL_FLAG = 'A'
\n\t ORDER BY GCC.SEGMENT1, GJH.PERIOD_NAME;<\/p>\n","protected":false},"excerpt":{"rendered":"

SELECT FFV1.DESCRIPTION \u673a\u6784\u540d\u79f0,     & … \u7ee7\u7eed\u9605\u8bfb\u5916\u90e8\u5ba1\u8ba1\u6570\u636e\u63d0\u53d6\u547d\u4ee4<\/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":[5,16],"tags":[],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/632"}],"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=632"}],"version-history":[{"count":1,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/632\/revisions"}],"predecessor-version":[{"id":633,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/632\/revisions\/633"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}