{"id":1243,"date":"2018-03-21T11:24:44","date_gmt":"2018-03-21T03:24:44","guid":{"rendered":"http:\/\/www.oracle.name\/?p=1243"},"modified":"2019-01-11T16:59:07","modified_gmt":"2019-01-11T08:59:07","slug":"oracle-ebs-%e4%ba%a4%e5%8f%89%e9%aa%8c%e8%af%81%e8%a7%84%e5%88%99%e5%af%bc%e5%87%ba","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=1243","title":{"rendered":"Oracle ebs \u4ea4\u53c9\u9a8c\u8bc1\u89c4\u5219\u5bfc\u51fa"},"content":{"rendered":"

\n\t–\u5df2\u6d4b\u8bd5\uff08\u4e24\u6bb5\u5747\u53ef\uff09\uff0c\u8bf7\u53d8\u66f4\u8d26\u5957\u540d
\n\tselect x.flex_validation_rule_name,
\n\t       x.description,
\n\t       h.include_exclude_indicator,
\n\t       h.concatenated_segments_low,
\n\t       h.concatenated_segments_high
\n\t  from apps.fnd_flex_vdation_rules_vl      x,
\n\t       apps.fnd_flex_validation_rule_lines h,
\n\t       gl_ledgers                          g
\n\t where 1 = 1
\n\t   and x.id_flex_num = g.chart_of_accounts_id
\n\t   and x.flex_validation_rule_name = h.flex_validation_rule_name
\n\t   and (h.id_flex_code = 'GL#')
\n\t   and (h.application_id = 101)
\n\t   and g.name = 'FIN_Ledger'
\n\t order by x.flex_validation_rule_name;\n<\/p>\n

\n\tSELECT FFCV.APPLICATION_NAME,
\n\t       FFCV.FLEX_STRUCTURE_NAME,
\n\t       FFVV.FLEX_VALIDATION_RULE_NAME,
\n\t       FFVV.DESCRIPTION,
\n\t       FFVV.ERROR_MESSAGE_TEXT \u9519\u8bef\u4fe1\u606f,
\n\t       DECODE(FFVL.INCLUDE_EXCLUDE_INDICATOR, 'I', '\u5305\u62ec', '\u6392\u9664') INCLUDE_EXCLUDE_INDICATOR,
\n\t       FFVL.CONCATENATED_SEGMENTS_LOW,
\n\t       FFVL.CONCATENATED_SEGMENTS_HIGH
\n\t  FROM FND_FLEX_CROSS_VALIDATION_V    FFCV,
\n\t       FND_FLEX_VDATION_RULES_VL      FFVV,
\n\t       FND_FLEX_VALIDATION_RULE_LINES FFVL
\n\t WHERE 1 = 1
\n\t   AND FFCV.APPLICATION_ID = FFVV.APPLICATION_ID
\n\t   AND FFCV.FLEX_CODE = FFVV.ID_FLEX_CODE
\n\t   AND FFCV.FLEX_STRUCTURE_NUM = FFVV.ID_FLEX_NUM
\n\t   AND FFVV.APPLICATION_ID = FFVL.APPLICATION_ID
\n\t   AND FFVV.ID_FLEX_CODE = FFVL.ID_FLEX_CODE
\n\t   AND FFVV.ID_FLEX_NUM = FFVL.ID_FLEX_NUM
\n\t   AND FFVV.FLEX_VALIDATION_RULE_NAME = FFVL.FLEX_VALIDATION_RULE_NAME
\n\t   AND FFCV.APPLICATION_ID = 101
\n\t   AND FFVV.ENABLED_FLAG = 'Y'
\n\t   AND FFVL.ENABLED_FLAG = 'Y';<\/p>\n","protected":false},"excerpt":{"rendered":"

–\u5df2\u6d4b\u8bd5\uff08\u4e24\u6bb5\u5747\u53ef\uff09\uff0c\u8bf7\u53d8\u66f4\u8d26\u5957\u540d select x.flex_validation_rule_n … \u7ee7\u7eed\u9605\u8bfbOracle ebs \u4ea4\u53c9\u9a8c\u8bc1\u89c4\u5219\u5bfc\u51fa<\/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":[25],"tags":[209],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1243"}],"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=1243"}],"version-history":[{"count":4,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1243\/revisions"}],"predecessor-version":[{"id":1412,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1243\/revisions\/1412"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}