Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XLA_PROD_SEG_RULES_FVL |
SELECT A.ROWID ROW_ID
, A.APPLICATION_ID APPLICATION_ID
, A.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, A.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, A.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, A.ENTITY_CODE ENTITY_CODE
, A.EVENT_CLASS_CODE EVENT_CLASS_CODE
, A.EVENT_TYPE_CODE EVENT_TYPE_CODE
, A.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, A.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, A.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, F.SEGMENT_NAME FLEXFIELD_SEGMENT_NAME
, F.SEGMENT_NUM FLEXFIELD_SEGMENT_NUM
, A.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, A.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, S.NAME SEGMENT_RULE_NAME
, L.MEANING SEGMENT_RULE_TYPE_CODE_DSP
, A.CREATION_DATE CREATION_DATE
, A.CREATED_BY CREATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_PROD_SEG_RULES A
, XLA_SEG_RULES_TL S
, FND_ID_FLEX_SEGMENTS_VL F
, XLA_PRODUCT_RULES_B LT
, XLA_LOOKUPS L
WHERE A.APPLICATION_ID = S.APPLICATION_ID
AND A.AMB_CONTEXT_CODE = S.AMB_CONTEXT_CODE
AND A.SEGMENT_RULE_TYPE_CODE = S.SEGMENT_RULE_TYPE_CODE
AND A.SEGMENT_RULE_CODE = S.SEGMENT_RULE_CODE
AND S.LANGUAGE = USERENV('LANG')
AND S.SEGMENT_RULE_TYPE_CODE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND A.FLEXFIELD_SEGMENT_CODE = F.APPLICATION_COLUMN_NAME
AND F.APPLICATION_ID = 101
AND F.ID_FLEX_CODE = 'GL#'
AND F.ID_FLEX_NUM = LT.ACCOUNTING_COA_ID
AND A.APPLICATION_ID = LT.APPLICATION_ID
AND A.AMB_CONTEXT_CODE = LT.AMB_CONTEXT_CODE
AND A.PRODUCT_RULE_TYPE_CODE = LT.PRODUCT_RULE_TYPE_CODE
AND A.PRODUCT_RULE_CODE = LT.PRODUCT_RULE_CODE
AND A.FLEXFIELD_SEGMENT_CODE <> 'ALL' UNION SELECT A.ROWID ROW_ID
, A.APPLICATION_ID APPLICATION_ID
, A.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, A.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, A.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, A.ENTITY_CODE ENTITY_CODE
, A.EVENT_CLASS_CODE EVENT_CLASS_CODE
, A.EVENT_TYPE_CODE EVENT_TYPE_CODE
, A.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, A.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, A.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, L2.MEANING FLEXFIELD_SEGMENT_NAME
, -1 FLEXFIELD_SEGMENT_NUM
, A.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, A.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, S.NAME SEGMENT_RULE_NAME
, L.MEANING SEGMENT_RULE_TYPE_CODE_DSP
, A.CREATION_DATE CREATION_DATE
, A.CREATED_BY CREATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_PROD_SEG_RULES A
, XLA_SEG_RULES_TL S
, XLA_LOOKUPS L2
, XLA_LOOKUPS L
WHERE A.APPLICATION_ID = S.APPLICATION_ID
AND A.AMB_CONTEXT_CODE = S.AMB_CONTEXT_CODE
AND A.SEGMENT_RULE_TYPE_CODE = S.SEGMENT_RULE_TYPE_CODE
AND A.SEGMENT_RULE_CODE = S.SEGMENT_RULE_CODE
AND S.LANGUAGE = USERENV('LANG')
AND S.SEGMENT_RULE_TYPE_CODE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND A.FLEXFIELD_SEGMENT_CODE = L2.LOOKUP_CODE
AND L2.LOOKUP_TYPE = 'XLA_FLEXFIELD_SEGMENTS_ALL'
AND A.FLEXFIELD_SEGMENT_CODE = 'ALL'