VIEW: APPS.XLA_PAD_INQ_LINES_SUB_FVL

Source

View Text - Preformatted

SELECT xjl.rowid row_id ,xjl.application_id application_id ,xjl.amb_context_code amb_context_code ,xal.product_rule_code product_rule_code ,xal.product_rule_type_code product_rule_type_code ,xal.line_definition_owner_code line_definition_owner_code ,xal.line_definition_code line_definition_code ,xpa.locking_status_flag locking_status_flag ,xjl.event_class_code event_class_code ,xjl.event_type_code event_type_code ,xjl.accounting_line_code accounting_line_code ,xjl.accounting_line_type_code accounting_line_type_code ,xjl.description_code description_code ,xjl.description_type_code description_type_code ,xad.segment_rule_code segment_rule_code ,srt.name segment_rule_name ,xad.segment_rule_type_code segment_rule_type_code ,l5.meaning segment_rule_type_code_dsp ,l12.meaning flexfield_assign_mode ,srb.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 ,xjl.creation_date creation_date ,xjl.created_by created_by ,xjl.last_update_date last_update_date ,xjl.last_update_login last_update_login ,xjl.last_updated_by last_updated_by FROM xla_line_defn_jlt_assgns xjl ,xla_aad_line_defn_assgns xal ,xla_prod_acct_headers xpa ,xla_line_defn_adr_assgns xad ,xla_seg_rules_tl srt ,xla_seg_rules_b srb ,xla_lookups l5 ,fnd_id_flex_structures_v ff ,xla_lookups l6 ,xla_lookups l12 WHERE xjl.application_id = xal.application_id AND xjl.amb_context_code = xal.amb_context_code AND xjl.event_class_code = xal.event_class_code AND xjl.event_type_code = xal.event_type_code AND xjl.line_definition_owner_code = xal.line_definition_owner_code AND xjl.line_definition_code = xal.line_definition_code AND xal.application_id = xpa.application_id AND xal.amb_context_code = xpa.amb_context_code AND xal.event_class_code = xpa.event_class_code AND xal.event_type_code = xpa.event_type_code AND xal.product_rule_type_code = xpa.product_rule_type_code AND xal.product_rule_code = xpa.product_rule_code AND xjl.application_id = xad.application_id AND xjl.amb_context_code = xad.amb_context_code AND xjl.event_class_code = xad.event_class_code AND xjl.event_type_code = xad.event_type_code AND xjl.line_definition_owner_code = xad.line_definition_owner_code AND xjl.line_definition_code = xad.line_definition_code AND xjl.accounting_line_type_code = xad.accounting_line_type_code AND xjl.accounting_line_code = xad.accounting_line_code AND xad.flexfield_segment_code = 'ALL' AND xad.application_id = srb.application_id AND xad.amb_context_code = srb.amb_context_code AND xad.segment_rule_type_code = srb.segment_rule_type_code AND xad.segment_rule_code = srb.segment_rule_code AND srb.application_id = srt.application_id AND srb.amb_context_code = srt.amb_context_code AND srb.segment_rule_type_code = srt.segment_rule_type_code AND srb.segment_rule_code = srt.segment_rule_code AND srt.language = USERENV('LANG') AND l5.lookup_type = 'XLA_OWNER_TYPE' AND xad.segment_rule_type_code = l5.lookup_code AND srb.accounting_coa_id = ff.id_flex_num(+) AND ff.id_flex_code(+) = 'GL#' AND ff.application_id(+) = 101 AND xad.flexfield_segment_code = l6.lookup_code AND l6.lookup_type = 'XLA_FLEXFIELD_SEGMENTS_ALL' AND 'A' = l12.lookup_code AND l12.lookup_type = 'XLA_ASSIGN_FLEX_MODE' AND not exists ( SELECT 'y' FROM xla_line_defn_adr_assgns ps WHERE xjl.application_id = ps.application_id AND xjl.amb_context_code = ps.amb_context_code AND xjl.event_class_code = ps.event_class_code AND xjl.event_type_code = ps.event_type_code AND xjl.line_definition_owner_code = ps.line_definition_owner_code AND xjl.line_definition_code = ps.line_definition_code AND xjl.accounting_line_type_code = ps.accounting_line_type_code AND xjl.accounting_line_code = ps.accounting_line_code AND ps.flexfield_segment_code != 'ALL') UNION /* journal entry lines with only Segment ADR */ SELECT xjl.rowid row_id ,xjl.application_id application_id ,xjl.amb_context_code amb_context_code ,xpa.product_rule_code product_rule_code ,xpa.product_rule_type_code product_rule_type_code ,xal.line_definition_owner_code line_definition_owner_code ,xal.line_definition_code line_definition_code ,xpa.locking_status_flag locking_status_flag ,xjl.event_class_code event_class_code ,xjl.event_type_code event_type_code ,xjl.accounting_line_code accounting_line_code ,xjl.accounting_line_type_code accounting_line_type_code ,xjl.description_code description_code ,xjl.description_type_code description_type_code ,null segment_rule_code ,null segment_rule_name ,null segment_rule_type_code ,null segment_rule_type_code_dsp ,l12.meaning flexfield_assign_mode ,xld.accounting_coa_id accounting_coa_id ,ff.id_flex_structure_name accounting_coa_name ,null flexfield_segment_code ,null flexfield_segment_name ,xjl.creation_date creation_date ,xjl.created_by created_by ,xjl.last_update_date last_update_date ,xjl.last_update_login last_update_login ,xjl.last_updated_by last_updated_by FROM xla_line_defn_jlt_assgns xjl ,xla_line_definitions_b xld ,xla_aad_line_defn_assgns xal ,xla_prod_acct_headers xpa ,fnd_id_flex_structures_v ff ,xla_lookups l12 WHERE xjl.application_id = xld.application_id AND xjl.amb_context_code = xld.amb_context_code AND xjl.event_class_code = xld.event_class_code AND xjl.event_type_code = xld.event_type_code AND xjl.line_definition_owner_code = xld.line_definition_owner_code AND xjl.line_definition_code = xld.line_definition_code AND xjl.application_id = xal.application_id AND xjl.amb_context_code = xal.amb_context_code AND xjl.event_class_code = xal.event_class_code AND xjl.event_type_code = xal.event_type_code AND xjl.line_definition_owner_code = xal.line_definition_owner_code AND xjl.line_definition_code = xal.line_definition_code AND xal.application_id = xpa.application_id AND xal.amb_context_code = xpa.amb_context_code AND xal.event_class_code = xpa.event_class_code AND xal.event_type_code = xpa.event_type_code AND xal.product_rule_type_code = xpa.product_rule_type_code AND xal.product_rule_code = xpa.product_rule_code AND xld.accounting_coa_id = ff.id_flex_num(+) AND ff.id_flex_code(+) = 'GL#' AND ff.application_id(+) = 101 AND 'S' = l12.lookup_code AND l12.lookup_type = 'XLA_ASSIGN_FLEX_MODE' AND exists ( SELECT 'y' FROM xla_line_defn_adr_assgns xad WHERE xjl.application_id = xad.application_id AND xjl.amb_context_code = xad.amb_context_code AND xjl.event_class_code = xad.event_class_code AND xjl.event_type_code = xad.event_type_code AND xjl.line_definition_owner_code = xad.line_definition_owner_code AND xjl.line_definition_code = xad.line_definition_code AND xjl.accounting_line_type_code = xad.accounting_line_type_code AND xjl.accounting_line_code = xad.accounting_line_code AND xad.flexfield_segment_code != 'ALL') AND not exists ( SELECT 'y' FROM xla_line_defn_adr_assgns xad WHERE xjl.application_id = xad.application_id AND xjl.amb_context_code = xad.amb_context_code AND xjl.event_class_code = xad.event_class_code AND xjl.event_type_code = xad.event_type_code AND xjl.line_definition_owner_code = xad.line_definition_owner_code AND xjl.line_definition_code = xad.line_definition_code AND xjl.accounting_line_type_code = xad.accounting_line_type_code AND xjl.accounting_line_code = xad.accounting_line_code AND xad.flexfield_segment_code = 'ALL') UNION /* journal entry lines with Accounting Flexfield and Segment ADR */ SELECT xjl.rowid row_id ,xjl.application_id application_id ,xjl.amb_context_code amb_context_code ,xal.product_rule_code product_rule_code ,xal.product_rule_type_code product_rule_type_code ,xal.line_definition_owner_code line_definition_owner_code ,xal.line_definition_code line_definition_code ,xpa.locking_status_flag locking_status_flag ,xjl.event_class_code event_class_code ,xjl.event_type_code event_type_code ,xjl.accounting_line_code accounting_line_code ,xjl.accounting_line_type_code accounting_line_type_code ,xjl.description_code description_code ,xjl.description_type_code description_type_code ,null segment_rule_code ,null segment_rule_name ,null segment_rule_type_code ,null segment_rule_type_code_dsp ,l12.meaning flexfield_assign_mode ,xld.accounting_coa_id accounting_coa_id ,ff.id_flex_structure_name accounting_coa_name ,null flexfield_segment_code ,null flexfield_segment_name ,xjl.creation_date creation_date ,xjl.created_by created_by ,xjl.last_update_date last_update_date ,xjl.last_update_login last_update_login ,xjl.last_updated_by last_updated_by FROM xla_line_defn_jlt_assgns xjl ,xla_line_definitions_b xld ,xla_aad_line_defn_assgns xal ,xla_prod_acct_headers xpa ,fnd_id_flex_structures_v ff ,fnd_lookups l12 WHERE xjl.application_id = xld.application_id AND xjl.amb_context_code = xld.amb_context_code AND xjl.event_class_code = xld.event_class_code AND xjl.event_type_code = xld.event_type_code AND xjl.line_definition_owner_code = xld.line_definition_owner_code AND xjl.line_definition_code = xld.line_definition_code AND xjl.application_id = xal.application_id AND xjl.amb_context_code = xal.amb_context_code AND xjl.event_class_code = xal.event_class_code AND xjl.event_type_code = xal.event_type_code AND xjl.line_definition_owner_code = xal.line_definition_owner_code AND xjl.line_definition_code = xal.line_definition_code AND xal.application_id = xpa.application_id AND xal.amb_context_code = xpa.amb_context_code AND xal.event_class_code = xpa.event_class_code AND xal.event_type_code = xpa.event_type_code AND xal.product_rule_type_code = xpa.product_rule_type_code AND xal.product_rule_code = xpa.product_rule_code AND xld.accounting_coa_id = ff.id_flex_num(+) AND ff.id_flex_code(+) = 'GL#' AND ff.application_id(+) = 101 AND 'B' = l12.lookup_code AND l12.lookup_type = 'BOTH_ALL_NONE' AND exists ( SELECT 'y' FROM xla_line_defn_adr_assgns xad WHERE xjl.application_id = xad.application_id AND xjl.amb_context_code = xad.amb_context_code AND xjl.event_class_code = xad.event_class_code AND xjl.event_type_code = xad.event_type_code AND xjl.line_definition_owner_code = xad.line_definition_owner_code AND xjl.line_definition_code = xad.line_definition_code AND xjl.accounting_line_type_code = xad.accounting_line_type_code AND xjl.accounting_line_code = xad.accounting_line_code AND xad.flexfield_segment_code != 'ALL') AND exists ( SELECT 'y' FROM xla_line_defn_adr_assgns xad WHERE xjl.application_id = xad.application_id AND xjl.amb_context_code = xad.amb_context_code AND xjl.event_class_code = xad.event_class_code AND xjl.event_type_code = xad.event_type_code AND xjl.line_definition_owner_code = xad.line_definition_owner_code AND xjl.line_definition_code = xad.line_definition_code AND xjl.accounting_line_type_code = xad.accounting_line_type_code AND xjl.accounting_line_code = xad.accounting_line_code AND xad.flexfield_segment_code = 'ALL') UNION /* journal entry lines with no segment rules */ SELECT xjl.rowid row_id ,xjl.application_id application_id ,xjl.amb_context_code amb_context_code ,xal.product_rule_code product_rule_code ,xal.product_rule_type_code product_rule_type_code ,xal.line_definition_owner_code line_definition_owner_code ,xal.line_definition_code line_definition_code ,xpa.locking_status_flag locking_status_flag ,xjl.event_class_code event_class_code ,xjl.event_type_code event_type_code ,xjl.accounting_line_code accounting_line_code ,xjl.accounting_line_type_code accounting_line_type_code ,xjl.description_code description_code ,xjl.description_type_code description_type_code ,null segment_rule_code ,null segment_rule_name ,null segment_rule_type_code ,null segment_rule_type_code_dsp ,null flexfield_assign_mode ,to_number(null) accounting_coa_id ,null accounting_coa_name ,null flexfield_segment_code ,null flexfield_segment_name ,xjl.creation_date creation_date ,xjl.created_by created_by ,xjl.last_update_date last_update_date ,xjl.last_update_login last_update_login ,xjl.last_updated_by last_updated_by FROM xla_line_defn_jlt_assgns xjl ,xla_aad_line_defn_assgns xal ,xla_prod_acct_headers xpa WHERE xjl.application_id = xal.application_id AND xjl.amb_context_code = xal.amb_context_code AND xjl.event_class_code = xal.event_class_code AND xjl.event_type_code = xal.event_type_code AND xjl.line_definition_owner_code = xal.line_definition_owner_code AND xjl.line_definition_code = xal.line_definition_code AND xal.application_id = xpa.application_id AND xal.amb_context_code = xpa.amb_context_code AND xal.event_class_code = xpa.event_class_code AND xal.event_type_code = xpa.event_type_code AND xal.product_rule_type_code = xpa.product_rule_type_code AND xal.product_rule_code = xpa.product_rule_code AND not exists ( SELECT 'y' FROM xla_line_defn_adr_assgns xad WHERE xjl.application_id = xad.application_id AND xjl.amb_context_code = xad.amb_context_code AND xjl.event_class_code = xad.event_class_code AND xjl.event_type_code = xad.event_type_code AND xjl.line_definition_owner_code = xad.line_definition_owner_code AND xjl.line_definition_code = xad.line_definition_code AND xjl.accounting_line_type_code = xad.accounting_line_type_code AND xjl.accounting_line_code = xad.accounting_line_code)

View Text - HTML Formatted

SELECT XJL.ROWID ROW_ID
, XJL.APPLICATION_ID APPLICATION_ID
, XJL.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XAL.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, XAL.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, XAL.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XAL.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XPA.LOCKING_STATUS_FLAG LOCKING_STATUS_FLAG
, XJL.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XJL.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XJL.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XJL.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XJL.DESCRIPTION_CODE DESCRIPTION_CODE
, XJL.DESCRIPTION_TYPE_CODE DESCRIPTION_TYPE_CODE
, XAD.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, SRT.NAME SEGMENT_RULE_NAME
, XAD.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, L5.MEANING SEGMENT_RULE_TYPE_CODE_DSP
, L12.MEANING FLEXFIELD_ASSIGN_MODE
, SRB.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
, XJL.CREATION_DATE CREATION_DATE
, XJL.CREATED_BY CREATED_BY
, XJL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XJL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, XJL.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_LINE_DEFN_JLT_ASSGNS XJL
, XLA_AAD_LINE_DEFN_ASSGNS XAL
, XLA_PROD_ACCT_HEADERS XPA
, XLA_LINE_DEFN_ADR_ASSGNS XAD
, XLA_SEG_RULES_TL SRT
, XLA_SEG_RULES_B SRB
, XLA_LOOKUPS L5
, FND_ID_FLEX_STRUCTURES_V FF
, XLA_LOOKUPS L6
, XLA_LOOKUPS L12
WHERE XJL.APPLICATION_ID = XAL.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = XAL.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = XAL.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XAL.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = XAL.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = XAL.LINE_DEFINITION_CODE
AND XAL.APPLICATION_ID = XPA.APPLICATION_ID
AND XAL.AMB_CONTEXT_CODE = XPA.AMB_CONTEXT_CODE
AND XAL.EVENT_CLASS_CODE = XPA.EVENT_CLASS_CODE
AND XAL.EVENT_TYPE_CODE = XPA.EVENT_TYPE_CODE
AND XAL.PRODUCT_RULE_TYPE_CODE = XPA.PRODUCT_RULE_TYPE_CODE
AND XAL.PRODUCT_RULE_CODE = XPA.PRODUCT_RULE_CODE
AND XJL.APPLICATION_ID = XAD.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = XAD.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = XAD.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XAD.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = XAD.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = XAD.LINE_DEFINITION_CODE
AND XJL.ACCOUNTING_LINE_TYPE_CODE = XAD.ACCOUNTING_LINE_TYPE_CODE
AND XJL.ACCOUNTING_LINE_CODE = XAD.ACCOUNTING_LINE_CODE
AND XAD.FLEXFIELD_SEGMENT_CODE = 'ALL'
AND XAD.APPLICATION_ID = SRB.APPLICATION_ID
AND XAD.AMB_CONTEXT_CODE = SRB.AMB_CONTEXT_CODE
AND XAD.SEGMENT_RULE_TYPE_CODE = SRB.SEGMENT_RULE_TYPE_CODE
AND XAD.SEGMENT_RULE_CODE = SRB.SEGMENT_RULE_CODE
AND SRB.APPLICATION_ID = SRT.APPLICATION_ID
AND SRB.AMB_CONTEXT_CODE = SRT.AMB_CONTEXT_CODE
AND SRB.SEGMENT_RULE_TYPE_CODE = SRT.SEGMENT_RULE_TYPE_CODE
AND SRB.SEGMENT_RULE_CODE = SRT.SEGMENT_RULE_CODE
AND SRT.LANGUAGE = USERENV('LANG')
AND L5.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND XAD.SEGMENT_RULE_TYPE_CODE = L5.LOOKUP_CODE
AND SRB.ACCOUNTING_COA_ID = FF.ID_FLEX_NUM(+)
AND FF.ID_FLEX_CODE(+) = 'GL#'
AND FF.APPLICATION_ID(+) = 101
AND XAD.FLEXFIELD_SEGMENT_CODE = L6.LOOKUP_CODE
AND L6.LOOKUP_TYPE = 'XLA_FLEXFIELD_SEGMENTS_ALL'
AND 'A' = L12.LOOKUP_CODE
AND L12.LOOKUP_TYPE = 'XLA_ASSIGN_FLEX_MODE'
AND NOT EXISTS ( SELECT 'Y'
FROM XLA_LINE_DEFN_ADR_ASSGNS PS
WHERE XJL.APPLICATION_ID = PS.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = PS.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = PS.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = PS.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = PS.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = PS.LINE_DEFINITION_CODE
AND XJL.ACCOUNTING_LINE_TYPE_CODE = PS.ACCOUNTING_LINE_TYPE_CODE
AND XJL.ACCOUNTING_LINE_CODE = PS.ACCOUNTING_LINE_CODE
AND PS.FLEXFIELD_SEGMENT_CODE != 'ALL') UNION /* JOURNAL ENTRY LINES WITH ONLY SEGMENT ADR */ SELECT XJL.ROWID ROW_ID
, XJL.APPLICATION_ID APPLICATION_ID
, XJL.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XPA.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, XPA.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, XAL.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XAL.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XPA.LOCKING_STATUS_FLAG LOCKING_STATUS_FLAG
, XJL.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XJL.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XJL.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XJL.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XJL.DESCRIPTION_CODE DESCRIPTION_CODE
, XJL.DESCRIPTION_TYPE_CODE DESCRIPTION_TYPE_CODE
, NULL SEGMENT_RULE_CODE
, NULL SEGMENT_RULE_NAME
, NULL SEGMENT_RULE_TYPE_CODE
, NULL SEGMENT_RULE_TYPE_CODE_DSP
, L12.MEANING FLEXFIELD_ASSIGN_MODE
, XLD.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, FF.ID_FLEX_STRUCTURE_NAME ACCOUNTING_COA_NAME
, NULL FLEXFIELD_SEGMENT_CODE
, NULL FLEXFIELD_SEGMENT_NAME
, XJL.CREATION_DATE CREATION_DATE
, XJL.CREATED_BY CREATED_BY
, XJL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XJL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, XJL.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_LINE_DEFN_JLT_ASSGNS XJL
, XLA_LINE_DEFINITIONS_B XLD
, XLA_AAD_LINE_DEFN_ASSGNS XAL
, XLA_PROD_ACCT_HEADERS XPA
, FND_ID_FLEX_STRUCTURES_V FF
, XLA_LOOKUPS L12
WHERE XJL.APPLICATION_ID = XLD.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = XLD.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = XLD.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XLD.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = XLD.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = XLD.LINE_DEFINITION_CODE
AND XJL.APPLICATION_ID = XAL.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = XAL.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = XAL.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XAL.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = XAL.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = XAL.LINE_DEFINITION_CODE
AND XAL.APPLICATION_ID = XPA.APPLICATION_ID
AND XAL.AMB_CONTEXT_CODE = XPA.AMB_CONTEXT_CODE
AND XAL.EVENT_CLASS_CODE = XPA.EVENT_CLASS_CODE
AND XAL.EVENT_TYPE_CODE = XPA.EVENT_TYPE_CODE
AND XAL.PRODUCT_RULE_TYPE_CODE = XPA.PRODUCT_RULE_TYPE_CODE
AND XAL.PRODUCT_RULE_CODE = XPA.PRODUCT_RULE_CODE
AND XLD.ACCOUNTING_COA_ID = FF.ID_FLEX_NUM(+)
AND FF.ID_FLEX_CODE(+) = 'GL#'
AND FF.APPLICATION_ID(+) = 101
AND 'S' = L12.LOOKUP_CODE
AND L12.LOOKUP_TYPE = 'XLA_ASSIGN_FLEX_MODE'
AND EXISTS ( SELECT 'Y'
FROM XLA_LINE_DEFN_ADR_ASSGNS XAD
WHERE XJL.APPLICATION_ID = XAD.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = XAD.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = XAD.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XAD.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = XAD.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = XAD.LINE_DEFINITION_CODE
AND XJL.ACCOUNTING_LINE_TYPE_CODE = XAD.ACCOUNTING_LINE_TYPE_CODE
AND XJL.ACCOUNTING_LINE_CODE = XAD.ACCOUNTING_LINE_CODE
AND XAD.FLEXFIELD_SEGMENT_CODE != 'ALL')
AND NOT EXISTS ( SELECT 'Y'
FROM XLA_LINE_DEFN_ADR_ASSGNS XAD
WHERE XJL.APPLICATION_ID = XAD.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = XAD.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = XAD.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XAD.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = XAD.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = XAD.LINE_DEFINITION_CODE
AND XJL.ACCOUNTING_LINE_TYPE_CODE = XAD.ACCOUNTING_LINE_TYPE_CODE
AND XJL.ACCOUNTING_LINE_CODE = XAD.ACCOUNTING_LINE_CODE
AND XAD.FLEXFIELD_SEGMENT_CODE = 'ALL') UNION /* JOURNAL ENTRY LINES WITH ACCOUNTING FLEXFIELD
AND SEGMENT ADR */ SELECT XJL.ROWID ROW_ID
, XJL.APPLICATION_ID APPLICATION_ID
, XJL.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XAL.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, XAL.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, XAL.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XAL.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XPA.LOCKING_STATUS_FLAG LOCKING_STATUS_FLAG
, XJL.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XJL.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XJL.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XJL.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XJL.DESCRIPTION_CODE DESCRIPTION_CODE
, XJL.DESCRIPTION_TYPE_CODE DESCRIPTION_TYPE_CODE
, NULL SEGMENT_RULE_CODE
, NULL SEGMENT_RULE_NAME
, NULL SEGMENT_RULE_TYPE_CODE
, NULL SEGMENT_RULE_TYPE_CODE_DSP
, L12.MEANING FLEXFIELD_ASSIGN_MODE
, XLD.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, FF.ID_FLEX_STRUCTURE_NAME ACCOUNTING_COA_NAME
, NULL FLEXFIELD_SEGMENT_CODE
, NULL FLEXFIELD_SEGMENT_NAME
, XJL.CREATION_DATE CREATION_DATE
, XJL.CREATED_BY CREATED_BY
, XJL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XJL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, XJL.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_LINE_DEFN_JLT_ASSGNS XJL
, XLA_LINE_DEFINITIONS_B XLD
, XLA_AAD_LINE_DEFN_ASSGNS XAL
, XLA_PROD_ACCT_HEADERS XPA
, FND_ID_FLEX_STRUCTURES_V FF
, FND_LOOKUPS L12
WHERE XJL.APPLICATION_ID = XLD.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = XLD.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = XLD.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XLD.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = XLD.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = XLD.LINE_DEFINITION_CODE
AND XJL.APPLICATION_ID = XAL.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = XAL.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = XAL.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XAL.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = XAL.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = XAL.LINE_DEFINITION_CODE
AND XAL.APPLICATION_ID = XPA.APPLICATION_ID
AND XAL.AMB_CONTEXT_CODE = XPA.AMB_CONTEXT_CODE
AND XAL.EVENT_CLASS_CODE = XPA.EVENT_CLASS_CODE
AND XAL.EVENT_TYPE_CODE = XPA.EVENT_TYPE_CODE
AND XAL.PRODUCT_RULE_TYPE_CODE = XPA.PRODUCT_RULE_TYPE_CODE
AND XAL.PRODUCT_RULE_CODE = XPA.PRODUCT_RULE_CODE
AND XLD.ACCOUNTING_COA_ID = FF.ID_FLEX_NUM(+)
AND FF.ID_FLEX_CODE(+) = 'GL#'
AND FF.APPLICATION_ID(+) = 101
AND 'B' = L12.LOOKUP_CODE
AND L12.LOOKUP_TYPE = 'BOTH_ALL_NONE'
AND EXISTS ( SELECT 'Y'
FROM XLA_LINE_DEFN_ADR_ASSGNS XAD
WHERE XJL.APPLICATION_ID = XAD.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = XAD.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = XAD.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XAD.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = XAD.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = XAD.LINE_DEFINITION_CODE
AND XJL.ACCOUNTING_LINE_TYPE_CODE = XAD.ACCOUNTING_LINE_TYPE_CODE
AND XJL.ACCOUNTING_LINE_CODE = XAD.ACCOUNTING_LINE_CODE
AND XAD.FLEXFIELD_SEGMENT_CODE != 'ALL')
AND EXISTS ( SELECT 'Y'
FROM XLA_LINE_DEFN_ADR_ASSGNS XAD
WHERE XJL.APPLICATION_ID = XAD.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = XAD.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = XAD.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XAD.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = XAD.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = XAD.LINE_DEFINITION_CODE
AND XJL.ACCOUNTING_LINE_TYPE_CODE = XAD.ACCOUNTING_LINE_TYPE_CODE
AND XJL.ACCOUNTING_LINE_CODE = XAD.ACCOUNTING_LINE_CODE
AND XAD.FLEXFIELD_SEGMENT_CODE = 'ALL') UNION /* JOURNAL ENTRY LINES WITH NO SEGMENT RULES */ SELECT XJL.ROWID ROW_ID
, XJL.APPLICATION_ID APPLICATION_ID
, XJL.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XAL.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, XAL.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, XAL.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XAL.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XPA.LOCKING_STATUS_FLAG LOCKING_STATUS_FLAG
, XJL.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XJL.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XJL.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XJL.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XJL.DESCRIPTION_CODE DESCRIPTION_CODE
, XJL.DESCRIPTION_TYPE_CODE DESCRIPTION_TYPE_CODE
, NULL SEGMENT_RULE_CODE
, NULL SEGMENT_RULE_NAME
, NULL SEGMENT_RULE_TYPE_CODE
, NULL SEGMENT_RULE_TYPE_CODE_DSP
, NULL FLEXFIELD_ASSIGN_MODE
, TO_NUMBER(NULL) ACCOUNTING_COA_ID
, NULL ACCOUNTING_COA_NAME
, NULL FLEXFIELD_SEGMENT_CODE
, NULL FLEXFIELD_SEGMENT_NAME
, XJL.CREATION_DATE CREATION_DATE
, XJL.CREATED_BY CREATED_BY
, XJL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XJL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, XJL.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_LINE_DEFN_JLT_ASSGNS XJL
, XLA_AAD_LINE_DEFN_ASSGNS XAL
, XLA_PROD_ACCT_HEADERS XPA
WHERE XJL.APPLICATION_ID = XAL.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = XAL.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = XAL.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XAL.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = XAL.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = XAL.LINE_DEFINITION_CODE
AND XAL.APPLICATION_ID = XPA.APPLICATION_ID
AND XAL.AMB_CONTEXT_CODE = XPA.AMB_CONTEXT_CODE
AND XAL.EVENT_CLASS_CODE = XPA.EVENT_CLASS_CODE
AND XAL.EVENT_TYPE_CODE = XPA.EVENT_TYPE_CODE
AND XAL.PRODUCT_RULE_TYPE_CODE = XPA.PRODUCT_RULE_TYPE_CODE
AND XAL.PRODUCT_RULE_CODE = XPA.PRODUCT_RULE_CODE
AND NOT EXISTS ( SELECT 'Y'
FROM XLA_LINE_DEFN_ADR_ASSGNS XAD
WHERE XJL.APPLICATION_ID = XAD.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = XAD.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = XAD.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XAD.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = XAD.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = XAD.LINE_DEFINITION_CODE
AND XJL.ACCOUNTING_LINE_TYPE_CODE = XAD.ACCOUNTING_LINE_TYPE_CODE
AND XJL.ACCOUNTING_LINE_CODE = XAD.ACCOUNTING_LINE_CODE)