View: XLA_PAD_INQ_SEG_RULES_FVL

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_PAD_INQ_SEG_RULES_FVL

View Text

SELECT XAD.APPLICATION_ID APPLICATION_ID
, XAD.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XAL.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, XAL.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, XAD.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XAD.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XAD.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XAD.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XAD.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XAD.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XAD.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, XST.NAME SEGMENT_RULE_NAME
, XAD.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, L5.MEANING SEGMENT_RULE_TYPE_CODE_DSP
, XSB.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, FF.ID_FLEX_STRUCTURE_NAME ACCOUNTING_COA_NAME
, XAD.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, L6.MEANING FLEXFIELD_SEGMENT_NAME
FROM XLA_LINE_DEFN_ADR_ASSGNS XAD JOIN XLA_AAD_LINE_DEFN_ASSGNS XAL ON XAD.APPLICATION_ID = XAL.APPLICATION_ID
AND XAD.AMB_CONTEXT_CODE = XAL.AMB_CONTEXT_CODE
AND XAD.EVENT_CLASS_CODE = XAL.EVENT_CLASS_CODE
AND XAD.EVENT_TYPE_CODE = XAL.EVENT_TYPE_CODE
AND XAD.LINE_DEFINITION_OWNER_CODE = XAL.LINE_DEFINITION_OWNER_CODE
AND XAD.LINE_DEFINITION_CODE = XAL.LINE_DEFINITION_CODE JOIN XLA_SEG_RULES_B XSB ON XAD.APPLICATION_ID = XSB.APPLICATION_ID
AND XAD.AMB_CONTEXT_CODE = XSB.AMB_CONTEXT_CODE
AND XAD.SEGMENT_RULE_TYPE_CODE = XSB.SEGMENT_RULE_TYPE_CODE
AND XAD.SEGMENT_RULE_CODE = XSB.SEGMENT_RULE_CODE JOIN XLA_SEG_RULES_TL XST ON XSB.APPLICATION_ID = XST.APPLICATION_ID
AND XSB.AMB_CONTEXT_CODE = XST.AMB_CONTEXT_CODE
AND XSB.SEGMENT_RULE_TYPE_CODE = XST.SEGMENT_RULE_TYPE_CODE
AND XSB.SEGMENT_RULE_CODE = XST.SEGMENT_RULE_CODE
AND XST.LANGUAGE = USERENV('LANG') LEFT OUTER JOIN FND_ID_FLEX_STRUCTURES_V FF ON XSB.ACCOUNTING_COA_ID = FF.ID_FLEX_NUM
AND FF.APPLICATION_ID = 101
AND FF.ID_FLEX_CODE = 'GL#' JOIN XLA_LOOKUPS L5 ON XAD.SEGMENT_RULE_TYPE_CODE = L5.LOOKUP_CODE
AND L5.LOOKUP_TYPE = 'XLA_OWNER_TYPE' JOIN XLA_LOOKUPS L6 ON XAD.FLEXFIELD_SEGMENT_CODE = L6.LOOKUP_CODE
AND L6.LOOKUP_TYPE = 'XLA_FLEXFIELD_SEGMENTS_ALL'
WHERE XAD.FLEXFIELD_SEGMENT_CODE = 'ALL' UNION SELECT XAD.APPLICATION_ID APPLICATION_ID
, XAD.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XAL.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, XAL.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, XAD.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XAD.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XAD.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XAD.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XAD.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XAD.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XAD.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, XST.NAME SEGMENT_RULE_NAME
, XAD.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, L5.MEANING SEGMENT_RULE_TYPE_CODE_DSP
, XSB.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, FF.ID_FLEX_STRUCTURE_NAME ACCOUNTING_COA_NAME
, XAD.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, FIF.SEGMENT_NAME FLEXFIELD_SEGMENT_NAME
FROM XLA_LINE_DEFN_ADR_ASSGNS XAD JOIN XLA_AAD_LINE_DEFN_ASSGNS XAL ON XAD.APPLICATION_ID = XAL.APPLICATION_ID
AND XAD.AMB_CONTEXT_CODE = XAL.AMB_CONTEXT_CODE
AND XAD.EVENT_CLASS_CODE = XAL.EVENT_CLASS_CODE
AND XAD.EVENT_TYPE_CODE = XAL.EVENT_TYPE_CODE
AND XAD.LINE_DEFINITION_OWNER_CODE = XAL.LINE_DEFINITION_OWNER_CODE
AND XAD.LINE_DEFINITION_CODE = XAL.LINE_DEFINITION_CODE JOIN XLA_SEG_RULES_B XSB ON XAD.APPLICATION_ID = XSB.APPLICATION_ID
AND XAD.AMB_CONTEXT_CODE = XSB.AMB_CONTEXT_CODE
AND XAD.SEGMENT_RULE_TYPE_CODE = XSB.SEGMENT_RULE_TYPE_CODE
AND XAD.SEGMENT_RULE_CODE = XSB.SEGMENT_RULE_CODE JOIN XLA_SEG_RULES_TL XST ON XSB.APPLICATION_ID = XST.APPLICATION_ID
AND XSB.AMB_CONTEXT_CODE = XST.AMB_CONTEXT_CODE
AND XSB.SEGMENT_RULE_TYPE_CODE = XST.SEGMENT_RULE_TYPE_CODE
AND XSB.SEGMENT_RULE_CODE = XST.SEGMENT_RULE_CODE
AND XST.LANGUAGE = USERENV('LANG') LEFT OUTER JOIN FND_ID_FLEX_STRUCTURES_V FF ON XSB.ACCOUNTING_COA_ID = FF.ID_FLEX_NUM
AND FF.APPLICATION_ID = 101
AND FF.ID_FLEX_CODE = 'GL#' JOIN FND_ID_FLEX_SEGMENTS_VL FIF ON XAD.FLEXFIELD_SEGMENT_CODE = FIF.APPLICATION_COLUMN_NAME
AND FIF.APPLICATION_ID = 101
AND FIF.ID_FLEX_CODE = 'GL#'
AND FIF.ID_FLEX_NUM = XSB.ACCOUNTING_COA_ID JOIN XLA_LOOKUPS L5 ON XAD.SEGMENT_RULE_TYPE_CODE = L5.LOOKUP_CODE
AND L5.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
WHERE XAD.FLEXFIELD_SEGMENT_CODE <> 'ALL'

Columns