Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XLA_SEG_RULES_FVL |
SELECT SRB.ROWID ROW_ID
, SRB.APPLICATION_ID APPLICATION_ID
, SRB.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, APL.APPLICATION_NAME APPLICATION_NAME
, SRB.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, LKP.MEANING SEGMENT_RULE_TYPE_DSP
, SRB.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, SRL.NAME NAME
, SRL.DESCRIPTION DESCRIPTION
, SRB.TRANSACTION_COA_ID TRANSACTION_COA_ID
, FLX1.ID_FLEX_STRUCTURE_NAME TRANSACTION_COA_NAME
, SRB.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, FLX2.ID_FLEX_STRUCTURE_NAME ACCOUNTING_COA_NAME
, SRB.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, NULL FLEXFIELD_SEGMENT_NAME
, SRB.FLEXFIELD_ASSIGN_MODE_CODE FLEXFIELD_ASSIGN_MODE_CODE
, SRB.ENABLED_FLAG ENABLED_FLAG
, SRB.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, NULL FLEX_VALUE_SET_NAME
, SRB.CREATION_DATE CREATION_DATE
, SRB.CREATED_BY CREATED_BY
, SRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SRB.LAST_UPDATED_BY LAST_UPDATED_BY
, SRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM XLA_SEG_RULES_B SRB
, XLA_SEG_RULES_TL SRL
, FND_APPLICATION_TL APL
, FND_ID_FLEX_STRUCTURES_TL FLX1
, FND_ID_FLEX_STRUCTURES_TL FLX2
, XLA_LOOKUPS LKP
WHERE SRB.APPLICATION_ID = SRL.APPLICATION_ID
AND SRB.AMB_CONTEXT_CODE = SRL.AMB_CONTEXT_CODE
AND SRB.SEGMENT_RULE_TYPE_CODE = SRL.SEGMENT_RULE_TYPE_CODE
AND SRB.SEGMENT_RULE_CODE = SRL.SEGMENT_RULE_CODE
AND SRL.LANGUAGE = USERENV('LANG')
AND SRB.APPLICATION_ID = APL.APPLICATION_ID
AND APL.LANGUAGE = USERENV('LANG')
AND SRB.SEGMENT_RULE_TYPE_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND SRB.TRANSACTION_COA_ID = FLX1.ID_FLEX_NUM(+)
AND FLX1.ID_FLEX_CODE(+) = 'GL#'
AND FLX1.APPLICATION_ID(+) = 101
AND FLX1.LANGUAGE (+) = USERENV('LANG')
AND SRB.ACCOUNTING_COA_ID = FLX2.ID_FLEX_NUM(+)
AND FLX2.ID_FLEX_CODE(+) = 'GL#'
AND FLX2.APPLICATION_ID(+) = 101
AND FLX2.LANGUAGE (+) = USERENV('LANG')
AND SRB.FLEXFIELD_ASSIGN_MODE_CODE = 'A' UNION SELECT SRB.ROWID ROW_ID
, SRB.APPLICATION_ID APPLICATION_ID
, SRB.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, APL.APPLICATION_NAME APPLICATION_NAME
, SRB.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, LKP.MEANING SEGMENT_RULE_TYPE_DSP
, SRB.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, SRL.NAME NAME
, SRL.DESCRIPTION DESCRIPTION
, SRB.TRANSACTION_COA_ID TRANSACTION_COA_ID
, FLX1.ID_FLEX_STRUCTURE_NAME TRANSACTION_COA_NAME
, SRB.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, FLX2.ID_FLEX_STRUCTURE_NAME ACCOUNTING_COA_NAME
, SRB.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, SAT.SEGMENT_NAME FLEXFIELD_SEGMENT_NAME
, SRB.FLEXFIELD_ASSIGN_MODE_CODE FLEXFIELD_ASSIGN_MODE_CODE
, SRB.ENABLED_FLAG ENABLED_FLAG
, SRB.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, NULL FLEX_VALUE_SET_NAME
, SRB.CREATION_DATE CREATION_DATE
, SRB.CREATED_BY CREATED_BY
, SRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SRB.LAST_UPDATED_BY LAST_UPDATED_BY
, SRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM XLA_SEG_RULES_B SRB
, XLA_SEG_RULES_TL SRL
, FND_APPLICATION_TL APL
, FND_ID_FLEX_STRUCTURES_TL FLX1
, FND_ID_FLEX_STRUCTURES_TL FLX2
, XLA_LOOKUPS LKP
, FND_ID_FLEX_SEGMENTS_VL SAT WHERE SRB.APPLICATION_ID = SRL.APPLICATION_ID
AND SRB.AMB_CONTEXT_CODE = SRL.AMB_CONTEXT_CODE
AND SRB.SEGMENT_RULE_TYPE_CODE = SRL.SEGMENT_RULE_TYPE_CODE
AND SRB.SEGMENT_RULE_CODE = SRL.SEGMENT_RULE_CODE
AND SRL.LANGUAGE = USERENV('LANG')
AND SRB.APPLICATION_ID = APL.APPLICATION_ID
AND APL.LANGUAGE = USERENV('LANG')
AND SRB.SEGMENT_RULE_TYPE_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND SRB.TRANSACTION_COA_ID = FLX1.ID_FLEX_NUM(+)
AND FLX1.ID_FLEX_CODE(+) = 'GL#'
AND FLX1.APPLICATION_ID(+) = 101
AND FLX1.LANGUAGE (+) = USERENV('LANG')
AND SRB.ACCOUNTING_COA_ID = FLX2.ID_FLEX_NUM(+)
AND FLX2.ID_FLEX_CODE(+) = 'GL#'
AND FLX2.APPLICATION_ID(+) = 101
AND FLX2.LANGUAGE (+) = USERENV('LANG')
AND SRB.FLEXFIELD_SEGMENT_CODE = SAT.APPLICATION_COLUMN_NAME
AND SAT.APPLICATION_ID = 101
AND SAT.ID_FLEX_CODE = 'GL#'
AND SAT.ID_FLEX_NUM = SRB.ACCOUNTING_COA_ID
AND SRB.FLEXFIELD_ASSIGN_MODE_CODE = 'S'
AND SRB.ACCOUNTING_COA_ID IS NOT NULL UNION SELECT SRB.ROWID ROW_ID
, SRB.APPLICATION_ID APPLICATION_ID
, SRB.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, APL.APPLICATION_NAME APPLICATION_NAME
, SRB.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, LKP.MEANING SEGMENT_RULE_TYPE_DSP
, SRB.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, SRL.NAME NAME
, SRL.DESCRIPTION DESCRIPTION
, SRB.TRANSACTION_COA_ID TRANSACTION_COA_ID
, FLX1.ID_FLEX_STRUCTURE_NAME TRANSACTION_COA_NAME
, SRB.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, NULL ACCOUNTING_COA_NAME
, SRB.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, SAT.SEGMENT_PROMPT FLEXFIELD_SEGMENT_NAME
, SRB.FLEXFIELD_ASSIGN_MODE_CODE FLEXFIELD_ASSIGN_MODE_CODE
, SRB.ENABLED_FLAG ENABLED_FLAG
, SRB.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, NULL FLEX_VALUE_SET_NAME
, SRB.CREATION_DATE CREATION_DATE
, SRB.CREATED_BY CREATED_BY
, SRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SRB.LAST_UPDATED_BY LAST_UPDATED_BY
, SRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM XLA_SEG_RULES_B SRB
, XLA_SEG_RULES_TL SRL
, FND_APPLICATION_TL APL
, FND_ID_FLEX_STRUCTURES_TL FLX1
, XLA_LOOKUPS LKP
, FND_SEGMENT_ATTRIBUTE_TYPES SAT WHERE SRB.APPLICATION_ID = SRL.APPLICATION_ID
AND SRB.AMB_CONTEXT_CODE = SRL.AMB_CONTEXT_CODE
AND SRB.SEGMENT_RULE_TYPE_CODE = SRL.SEGMENT_RULE_TYPE_CODE
AND SRB.SEGMENT_RULE_CODE = SRL.SEGMENT_RULE_CODE
AND SRL.LANGUAGE = USERENV('LANG')
AND SRB.APPLICATION_ID = APL.APPLICATION_ID
AND APL.LANGUAGE = USERENV('LANG')
AND SRB.SEGMENT_RULE_TYPE_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND SRB.TRANSACTION_COA_ID = FLX1.ID_FLEX_NUM(+)
AND FLX1.ID_FLEX_CODE(+) = 'GL#'
AND FLX1.APPLICATION_ID(+) = 101
AND FLX1.LANGUAGE (+) = USERENV('LANG')
AND SRB.FLEXFIELD_SEGMENT_CODE = SAT.SEGMENT_ATTRIBUTE_TYPE
AND SAT.APPLICATION_ID = 101
AND SAT.ID_FLEX_CODE = 'GL#'
AND SRB.FLEXFIELD_ASSIGN_MODE_CODE = 'S'
AND SRB.ACCOUNTING_COA_ID IS NULL UNION SELECT SRB.ROWID ROW_ID
, SRB.APPLICATION_ID APPLICATION_ID
, SRB.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, APL.APPLICATION_NAME APPLICATION_NAME
, SRB.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, LKP.MEANING SEGMENT_RULE_TYPE_DSP
, SRB.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, SRL.NAME NAME
, SRL.DESCRIPTION DESCRIPTION
, SRB.TRANSACTION_COA_ID TRANSACTION_COA_ID
, FLX1.ID_FLEX_STRUCTURE_NAME TRANSACTION_COA_NAME
, SRB.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, NULL ACCOUNTING_COA_NAME
, SRB.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, NULL FLEXFIELD_SEGMENT_NAME
, SRB.FLEXFIELD_ASSIGN_MODE_CODE FLEXFIELD_ASSIGN_MODE_CODE
, SRB.ENABLED_FLAG ENABLED_FLAG
, SRB.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, FLX.FLEX_VALUE_SET_NAME FLEX_VALUE_SET_NAME
, SRB.CREATION_DATE CREATION_DATE
, SRB.CREATED_BY CREATED_BY
, SRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SRB.LAST_UPDATED_BY LAST_UPDATED_BY
, SRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM XLA_SEG_RULES_B SRB
, XLA_SEG_RULES_TL SRL
, FND_APPLICATION_TL APL
, FND_ID_FLEX_STRUCTURES_TL FLX1
, XLA_LOOKUPS LKP
, FND_FLEX_VALUE_SETS FLX WHERE SRB.APPLICATION_ID = SRL.APPLICATION_ID
AND SRB.AMB_CONTEXT_CODE = SRL.AMB_CONTEXT_CODE
AND SRB.SEGMENT_RULE_TYPE_CODE = SRL.SEGMENT_RULE_TYPE_CODE
AND SRB.SEGMENT_RULE_CODE = SRL.SEGMENT_RULE_CODE
AND SRL.LANGUAGE = USERENV('LANG')
AND SRB.APPLICATION_ID = APL.APPLICATION_ID
AND APL.LANGUAGE = USERENV('LANG')
AND SRB.SEGMENT_RULE_TYPE_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND SRB.TRANSACTION_COA_ID = FLX1.ID_FLEX_NUM(+)
AND FLX1.ID_FLEX_CODE(+) = 'GL#'
AND FLX1.APPLICATION_ID(+) = 101
AND FLX1.LANGUAGE (+) = USERENV('LANG')
AND SRB.FLEXFIELD_ASSIGN_MODE_CODE = 'V'
AND SRB.FLEX_VALUE_SET_ID = FLX.FLEX_VALUE_SET_ID