VIEW: APPS.XLA_LINE_DEFN_ADR_ASSGNS_F_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')