View: XLA_LINE_DEFN_ADR_ASSGNS_F_V

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

View Text

SELECT XLD.ROWID ROW_ID
, XLD.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XLD.APPLICATION_ID APPLICATION_ID
, XLD.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XLD.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XLD.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XLD.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XLD.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XLD.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XLD.SIDE_CODE SIDE_CODE
, DECODE(XLD.SIDE_CODE
, 'NA'
, NULL
, LK1.MEANING) SIDE_CODE_DSP
, XLD.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, LK2.MEANING FLEXFIELD_SEGMENT_NAME
, -1 FLEXFIELD_SEGMENT_NUM
, XLD.INHERIT_ADR_FLAG INHERIT_ADR_FLAG
, XSR.NAME SEGMENT_RULE_NAME
, XLD.SEGMENT_RULE_APPL_ID SEGMENT_RULE_APPL_ID
, XLD.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, LK.MEANING SEGMENT_RULE_OWNER
, XLD.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, XSR.DESCRIPTION SEGMENT_RULE_DESC
, XLD.OBJECT_VERSION_NUMBER
, XLD.CREATION_DATE
, XLD.CREATED_BY
, XLD.LAST_UPDATE_DATE
, XLD.LAST_UPDATED_BY
, XLD.LAST_UPDATE_LOGIN
FROM XLA_LINE_DEFN_ADR_ASSGNS XLD LEFT OUTER JOIN XLA_SEG_RULES_TL XSR ON XSR.LANGUAGE = USERENV('LANG')
AND XSR.SEGMENT_RULE_TYPE_CODE = XLD.SEGMENT_RULE_TYPE_CODE
AND XSR.SEGMENT_RULE_CODE = XLD.SEGMENT_RULE_CODE
AND XSR.APPLICATION_ID = XLD.SEGMENT_RULE_APPL_ID
AND XSR.AMB_CONTEXT_CODE = XLD.AMB_CONTEXT_CODE LEFT OUTER JOIN XLA_LOOKUPS LK ON LK.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND XLD.SEGMENT_RULE_TYPE_CODE = LK.LOOKUP_CODE JOIN XLA_LOOKUPS LK2 ON LK2.LOOKUP_TYPE = 'XLA_FLEXFIELD_SEGMENTS_ALL'
AND XLD.FLEXFIELD_SEGMENT_CODE = LK2.LOOKUP_CODE JOIN XLA_LOOKUPS LK1 ON LK1.LOOKUP_TYPE = 'XLA_ADR_SIDE'
AND LK1.LOOKUP_CODE = XLD.SIDE_CODE
WHERE XLD.FLEXFIELD_SEGMENT_CODE = 'ALL' UNION SELECT XLD.ROWID ROW_ID
, XLD.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XLD.APPLICATION_ID APPLICATION_ID
, XLD.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XLD.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XLD.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XLD.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XLD.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XLD.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XLD.SIDE_CODE SIDE_CODE
, DECODE(XLD.SIDE_CODE
, 'NA'
, NULL
, LK1.MEANING) SIDE_CODE_DSP
, XLD.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, FIF.SEGMENT_NAME FLEXFIELD_SEGMENT_NAME
, FIF.SEGMENT_NUM FLEXFIELD_SEGMENT_NUM
, XLD.INHERIT_ADR_FLAG INHERIT_ADR_FLAG
, XSR.NAME SEGMENT_RULE_NAME
, XLD.SEGMENT_RULE_APPL_ID SEGMENT_RULE_APPL_ID
, XLD.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, LK.MEANING SEGMENT_RULE_OWNER
, XLD.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, XSR.DESCRIPTION SEGMENT_RULE_DESC
, XLD.OBJECT_VERSION_NUMBER
, XLD.CREATION_DATE
, XLD.CREATED_BY
, XLD.LAST_UPDATE_DATE
, XLD.LAST_UPDATED_BY
, XLD.LAST_UPDATE_LOGIN
FROM XLA_LINE_DEFN_ADR_ASSGNS XLD LEFT OUTER JOIN XLA_SEG_RULES_TL XSR ON XSR.LANGUAGE = USERENV('LANG')
AND XSR.SEGMENT_RULE_TYPE_CODE = XLD.SEGMENT_RULE_TYPE_CODE
AND XSR.SEGMENT_RULE_CODE = XLD.SEGMENT_RULE_CODE
AND XSR.APPLICATION_ID = XLD.SEGMENT_RULE_APPL_ID
AND XSR.AMB_CONTEXT_CODE = XLD.AMB_CONTEXT_CODE JOIN XLA_LINE_DEFINITIONS_B LLA ON XLD.APPLICATION_ID = LLA.APPLICATION_ID
AND XLD.AMB_CONTEXT_CODE = LLA.AMB_CONTEXT_CODE
AND XLD.EVENT_CLASS_CODE = LLA.EVENT_CLASS_CODE
AND XLD.EVENT_TYPE_CODE = LLA.EVENT_TYPE_CODE
AND XLD.LINE_DEFINITION_OWNER_CODE = LLA.LINE_DEFINITION_OWNER_CODE
AND XLD.LINE_DEFINITION_CODE = LLA.LINE_DEFINITION_CODE LEFT OUTER JOIN XLA_LOOKUPS LK ON LK.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND XLD.SEGMENT_RULE_TYPE_CODE = LK.LOOKUP_CODE LEFT OUTER JOIN FND_ID_FLEX_SEGMENTS_VL FIF ON XLD.FLEXFIELD_SEGMENT_CODE = FIF.APPLICATION_COLUMN_NAME
AND FIF.APPLICATION_ID = 101
AND FIF.ID_FLEX_CODE = 'GL#'
AND FIF.ID_FLEX_NUM = LLA.ACCOUNTING_COA_ID JOIN XLA_LOOKUPS LK1 ON LK1.LOOKUP_TYPE = 'XLA_ADR_SIDE'
AND LK1.LOOKUP_CODE = XLD.SIDE_CODE
WHERE XLD.FLEXFIELD_SEGMENT_CODE NOT IN ('ALL'
, 'GL_BALANCING'
, 'GL_ACCOUNT'
, 'FA_COST_CTR'
, 'GL_INTERCOMPANY'
, 'GL_MANAGEMENT') UNION SELECT XLD.ROWID ROW_ID
, XLD.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XLD.APPLICATION_ID APPLICATION_ID
, XLD.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XLD.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XLD.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XLD.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XLD.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XLD.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XLD.SIDE_CODE SIDE_CODE
, DECODE(XLD.SIDE_CODE
, 'NA'
, NULL
, LK1.MEANING) SIDE_CODE_DSP
, XLD.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, SAT.SEGMENT_PROMPT FLEXFIELD_SEGMENT_NAME
, -1 FLEXFIELD_SEGMENT_NUM
, XLD.INHERIT_ADR_FLAG INHERIT_ADR_FLAG
, XSR.NAME SEGMENT_RULE_NAME
, XLD.SEGMENT_RULE_APPL_ID SEGMENT_RULE_APPL_ID
, XLD.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, LK.MEANING SEGMENT_RULE_OWNER
, XLD.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, XSR.DESCRIPTION SEGMENT_RULE_DESC
, XLD.OBJECT_VERSION_NUMBER
, XLD.CREATION_DATE
, XLD.CREATED_BY
, XLD.LAST_UPDATE_DATE
, XLD.LAST_UPDATED_BY
, XLD.LAST_UPDATE_LOGIN
FROM XLA_LINE_DEFN_ADR_ASSGNS XLD LEFT OUTER JOIN XLA_SEG_RULES_TL XSR ON XSR.LANGUAGE = USERENV('LANG')
AND XSR.SEGMENT_RULE_TYPE_CODE = XLD.SEGMENT_RULE_TYPE_CODE
AND XSR.SEGMENT_RULE_CODE = XLD.SEGMENT_RULE_CODE
AND XSR.APPLICATION_ID = XLD.SEGMENT_RULE_APPL_ID
AND XSR.AMB_CONTEXT_CODE = XLD.AMB_CONTEXT_CODE LEFT OUTER JOIN XLA_LOOKUPS LK ON LK.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND XLD.SEGMENT_RULE_TYPE_CODE = LK.LOOKUP_CODE LEFT OUTER JOIN FND_SEGMENT_ATTRIBUTE_TYPES SAT ON XLD.FLEXFIELD_SEGMENT_CODE = SAT.SEGMENT_ATTRIBUTE_TYPE
AND SAT.APPLICATION_ID = 101
AND SAT.ID_FLEX_CODE = 'GL#' JOIN XLA_LOOKUPS LK1 ON LK1.LOOKUP_TYPE = 'XLA_ADR_SIDE'
AND LK1.LOOKUP_CODE = XLD.SIDE_CODE
WHERE XLD.FLEXFIELD_SEGMENT_CODE IN ('GL_BALANCING'
, 'GL_ACCOUNT'
, 'FA_COST_CTR'
, 'GL_INTERCOMPANY'
, 'GL_MANAGEMENT')

Columns