VIEW: APPS.XLA_PAD_INQ_LINES_AC_AF_FVL

Source

View Text - Preformatted

SELECT xjl.application_id application_id ,xjl.amb_context_code amb_context_code ,xal.product_rule_code product_rule_code ,prt.name product_rule_name ,xal.product_rule_type_code product_rule_type_code ,l1.meaning product_rule_type_code_dsp ,xjl.line_definition_owner_code line_definition_owner_code ,l13.meaning line_definition_owner ,xjl.line_definition_code line_definition_code ,xld.name line_definition_name ,xpa.locking_status_flag locking_status_flag ,xjl.event_class_code event_class_code ,xec.name event_class_name ,xjl.event_type_code event_type_code ,xet.name event_type_name ,xjl.accounting_line_code accounting_line_code ,ltt.name accounting_line_name ,xjl.accounting_line_type_code accounting_line_type_code ,l2.meaning accounting_line_type_code_dsp ,ltb.accounting_entry_type_code accounting_entry_type_code ,l7.meaning accounting_entry_type_dsp ,ltb.accounting_class_code accounting_class_code ,l11.meaning accounting_class_name ,ltb.natural_side_code accounting_line_side_code ,l8.meaning accounting_line_side_dsp ,ltb.switch_side_flag switch_side_flag ,l9.meaning switch_side_flag_dsp ,ltb.merge_duplicate_code merge_duplicate_code ,l10.meaning merge_duplicate_dsp ,xjl.description_code description_code ,xdt.name description_name ,xjl.description_type_code description_type_code ,l3.meaning description_type_code_dsp ,xac.analytical_criterion_code analytical_criterion_code ,xac.analytical_criterion_type_code analytical_criterion_type_code ,xst.segment_rule_code segment_rule_code ,xst.name segment_rule_name ,xst.segment_rule_type_code segment_rule_type_code ,l5.meaning segment_rule_type_code_dsp ,l12.meaning flexfield_assign_mode ,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 ,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_adr_assgns xad JOIN xla_line_defn_jlt_assgns xjl ON 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 JOIN xla_line_definitions_tl xld ON xld.application_id = xad.application_id AND xld.amb_context_code = xad.amb_context_code AND xld.event_class_code = xad.event_class_code AND xld.event_type_code = xad.event_type_code AND xld.line_definition_owner_code = xad.line_definition_owner_code AND xld.line_definition_code = xad.line_definition_code AND xld.language = USERENV('LANG') JOIN xla_aad_line_defn_assgns xal ON 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 JOIN xla_prod_acct_headers xpa ON 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 JOIN xla_product_rules_tl prt ON xal.application_id = prt.application_id AND xal.amb_context_code = prt.amb_context_code AND xal.product_rule_type_code = prt.product_rule_type_code AND xal.product_rule_code = prt.product_rule_code AND prt.language = USERENV('LANG') JOIN xla_event_classes_tl xec ON xjl.application_id = xec.application_id AND xjl.event_class_code = xec.event_class_code AND xec.language = USERENV('LANG') JOIN xla_event_types_tl xet ON xjl.application_id = xet.application_id AND xjl.event_class_code = xet.event_class_code AND xjl.event_type_code = xet.event_type_code AND xet.language = USERENV('LANG') JOIN xla_acct_line_types_b ltb ON xjl.application_id = ltb.application_id AND xjl.amb_context_code = ltb.amb_context_code AND xjl.event_class_code = ltb.event_class_code AND xjl.accounting_line_type_code = ltb.accounting_line_type_code AND xjl.accounting_line_code = ltb.accounting_line_code JOIN xla_acct_line_types_tl ltt ON ltb.application_id = ltt.application_id AND ltb.amb_context_code = ltt.amb_context_code AND ltb.event_class_code = ltt.event_class_code AND ltb.accounting_line_type_code = ltt.accounting_line_type_code AND ltb.accounting_line_code = ltt.accounting_line_code AND ltt.language = USERENV('LANG') LEFT OUTER JOIN xla_descriptions_tl xdt ON xjl.application_id = xdt.application_id AND xjl.amb_context_code = xdt.amb_context_code AND xjl.description_type_code = xdt.description_type_code AND xjl.description_code = xdt.description_code AND xdt.language = USERENV('LANG') JOIN xla_line_defn_ac_assgns xac ON xjl.application_id = xac.application_id AND xjl.amb_context_code = xac.amb_context_code AND xjl.event_class_code = xac.event_class_code AND xjl.event_type_code = xac.event_type_code AND xjl.line_definition_owner_code = xac.line_definition_owner_code AND xjl.line_definition_code = xac.line_definition_code AND xjl.accounting_line_type_code = xac.accounting_line_type_code AND xjl.accounting_line_code = xac.accounting_line_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 xad.application_id = xst.application_id AND xad.amb_context_code = xst.amb_context_code AND xad.segment_rule_type_code = xst.segment_rule_type_code AND xad.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 l1 ON xal.product_rule_type_code = l1.lookup_code AND l1.lookup_type = 'XLA_OWNER_TYPE' JOIN xla_lookups l2 ON xjl.accounting_line_type_code = l2.lookup_code AND l2.lookup_type = 'XLA_OWNER_TYPE' LEFT OUTER JOIN xla_lookups l3 ON xjl.description_type_code = l3.lookup_code AND l3.lookup_type = 'XLA_OWNER_TYPE' 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' JOIN xla_lookups l7 ON ltb.accounting_entry_type_code = l7.lookup_code AND l7.lookup_type = 'XLA_BALANCE_TYPE' JOIN xla_lookups l8 ON ltb.natural_side_code = l8.lookup_code AND l8.lookup_type = 'XLA_ACCT_NATURAL_SIDE' JOIN xla_lookups l9 ON ltb.switch_side_flag = l9.lookup_code AND l9.lookup_type = 'XLA_YES_NO' JOIN xla_lookups l10 ON ltb.merge_duplicate_code = l10.lookup_code AND l10.lookup_type = 'XLA_MERGE_MATCHING_TYPE' JOIN xla_lookups l11 ON ltb.accounting_class_code = l11.lookup_code AND l11.lookup_type = 'XLA_ACCOUNTING_CLASS' JOIN xla_lookups l12 ON 'A' = l12.lookup_code AND l12.lookup_type = 'XLA_ASSIGN_FLEX_MODE' JOIN xla_lookups l13 ON xld.line_definition_owner_code = l13.lookup_code AND l13.lookup_type = 'XLA_OWNER_TYPE' WHERE xad.flexfield_segment_code = 'ALL'

View Text - HTML Formatted

SELECT XJL.APPLICATION_ID APPLICATION_ID
, XJL.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XAL.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, PRT.NAME PRODUCT_RULE_NAME
, XAL.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, L1.MEANING PRODUCT_RULE_TYPE_CODE_DSP
, XJL.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, L13.MEANING LINE_DEFINITION_OWNER
, XJL.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XLD.NAME LINE_DEFINITION_NAME
, XPA.LOCKING_STATUS_FLAG LOCKING_STATUS_FLAG
, XJL.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XEC.NAME EVENT_CLASS_NAME
, XJL.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XET.NAME EVENT_TYPE_NAME
, XJL.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, LTT.NAME ACCOUNTING_LINE_NAME
, XJL.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, L2.MEANING ACCOUNTING_LINE_TYPE_CODE_DSP
, LTB.ACCOUNTING_ENTRY_TYPE_CODE ACCOUNTING_ENTRY_TYPE_CODE
, L7.MEANING ACCOUNTING_ENTRY_TYPE_DSP
, LTB.ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE
, L11.MEANING ACCOUNTING_CLASS_NAME
, LTB.NATURAL_SIDE_CODE ACCOUNTING_LINE_SIDE_CODE
, L8.MEANING ACCOUNTING_LINE_SIDE_DSP
, LTB.SWITCH_SIDE_FLAG SWITCH_SIDE_FLAG
, L9.MEANING SWITCH_SIDE_FLAG_DSP
, LTB.MERGE_DUPLICATE_CODE MERGE_DUPLICATE_CODE
, L10.MEANING MERGE_DUPLICATE_DSP
, XJL.DESCRIPTION_CODE DESCRIPTION_CODE
, XDT.NAME DESCRIPTION_NAME
, XJL.DESCRIPTION_TYPE_CODE DESCRIPTION_TYPE_CODE
, L3.MEANING DESCRIPTION_TYPE_CODE_DSP
, XAC.ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE
, XAC.ANALYTICAL_CRITERION_TYPE_CODE ANALYTICAL_CRITERION_TYPE_CODE
, XST.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, XST.NAME SEGMENT_RULE_NAME
, XST.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, L5.MEANING SEGMENT_RULE_TYPE_CODE_DSP
, L12.MEANING FLEXFIELD_ASSIGN_MODE
, 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
, 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_ADR_ASSGNS XAD JOIN XLA_LINE_DEFN_JLT_ASSGNS XJL ON 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 JOIN XLA_LINE_DEFINITIONS_TL XLD ON XLD.APPLICATION_ID = XAD.APPLICATION_ID
AND XLD.AMB_CONTEXT_CODE = XAD.AMB_CONTEXT_CODE
AND XLD.EVENT_CLASS_CODE = XAD.EVENT_CLASS_CODE
AND XLD.EVENT_TYPE_CODE = XAD.EVENT_TYPE_CODE
AND XLD.LINE_DEFINITION_OWNER_CODE = XAD.LINE_DEFINITION_OWNER_CODE
AND XLD.LINE_DEFINITION_CODE = XAD.LINE_DEFINITION_CODE
AND XLD.LANGUAGE = USERENV('LANG') JOIN XLA_AAD_LINE_DEFN_ASSGNS XAL ON 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 JOIN XLA_PROD_ACCT_HEADERS XPA ON 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 JOIN XLA_PRODUCT_RULES_TL PRT ON XAL.APPLICATION_ID = PRT.APPLICATION_ID
AND XAL.AMB_CONTEXT_CODE = PRT.AMB_CONTEXT_CODE
AND XAL.PRODUCT_RULE_TYPE_CODE = PRT.PRODUCT_RULE_TYPE_CODE
AND XAL.PRODUCT_RULE_CODE = PRT.PRODUCT_RULE_CODE
AND PRT.LANGUAGE = USERENV('LANG') JOIN XLA_EVENT_CLASSES_TL XEC ON XJL.APPLICATION_ID = XEC.APPLICATION_ID
AND XJL.EVENT_CLASS_CODE = XEC.EVENT_CLASS_CODE
AND XEC.LANGUAGE = USERENV('LANG') JOIN XLA_EVENT_TYPES_TL XET ON XJL.APPLICATION_ID = XET.APPLICATION_ID
AND XJL.EVENT_CLASS_CODE = XET.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XET.EVENT_TYPE_CODE
AND XET.LANGUAGE = USERENV('LANG') JOIN XLA_ACCT_LINE_TYPES_B LTB ON XJL.APPLICATION_ID = LTB.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = LTB.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = LTB.EVENT_CLASS_CODE
AND XJL.ACCOUNTING_LINE_TYPE_CODE = LTB.ACCOUNTING_LINE_TYPE_CODE
AND XJL.ACCOUNTING_LINE_CODE = LTB.ACCOUNTING_LINE_CODE JOIN XLA_ACCT_LINE_TYPES_TL LTT ON LTB.APPLICATION_ID = LTT.APPLICATION_ID
AND LTB.AMB_CONTEXT_CODE = LTT.AMB_CONTEXT_CODE
AND LTB.EVENT_CLASS_CODE = LTT.EVENT_CLASS_CODE
AND LTB.ACCOUNTING_LINE_TYPE_CODE = LTT.ACCOUNTING_LINE_TYPE_CODE
AND LTB.ACCOUNTING_LINE_CODE = LTT.ACCOUNTING_LINE_CODE
AND LTT.LANGUAGE = USERENV('LANG') LEFT OUTER JOIN XLA_DESCRIPTIONS_TL XDT ON XJL.APPLICATION_ID = XDT.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = XDT.AMB_CONTEXT_CODE
AND XJL.DESCRIPTION_TYPE_CODE = XDT.DESCRIPTION_TYPE_CODE
AND XJL.DESCRIPTION_CODE = XDT.DESCRIPTION_CODE
AND XDT.LANGUAGE = USERENV('LANG') JOIN XLA_LINE_DEFN_AC_ASSGNS XAC ON XJL.APPLICATION_ID = XAC.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = XAC.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = XAC.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XAC.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = XAC.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = XAC.LINE_DEFINITION_CODE
AND XJL.ACCOUNTING_LINE_TYPE_CODE = XAC.ACCOUNTING_LINE_TYPE_CODE
AND XJL.ACCOUNTING_LINE_CODE = XAC.ACCOUNTING_LINE_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 XAD.APPLICATION_ID = XST.APPLICATION_ID
AND XAD.AMB_CONTEXT_CODE = XST.AMB_CONTEXT_CODE
AND XAD.SEGMENT_RULE_TYPE_CODE = XST.SEGMENT_RULE_TYPE_CODE
AND XAD.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 L1 ON XAL.PRODUCT_RULE_TYPE_CODE = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'XLA_OWNER_TYPE' JOIN XLA_LOOKUPS L2 ON XJL.ACCOUNTING_LINE_TYPE_CODE = L2.LOOKUP_CODE
AND L2.LOOKUP_TYPE = 'XLA_OWNER_TYPE' LEFT OUTER JOIN XLA_LOOKUPS L3 ON XJL.DESCRIPTION_TYPE_CODE = L3.LOOKUP_CODE
AND L3.LOOKUP_TYPE = 'XLA_OWNER_TYPE' 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' JOIN XLA_LOOKUPS L7 ON LTB.ACCOUNTING_ENTRY_TYPE_CODE = L7.LOOKUP_CODE
AND L7.LOOKUP_TYPE = 'XLA_BALANCE_TYPE' JOIN XLA_LOOKUPS L8 ON LTB.NATURAL_SIDE_CODE = L8.LOOKUP_CODE
AND L8.LOOKUP_TYPE = 'XLA_ACCT_NATURAL_SIDE' JOIN XLA_LOOKUPS L9 ON LTB.SWITCH_SIDE_FLAG = L9.LOOKUP_CODE
AND L9.LOOKUP_TYPE = 'XLA_YES_NO' JOIN XLA_LOOKUPS L10 ON LTB.MERGE_DUPLICATE_CODE = L10.LOOKUP_CODE
AND L10.LOOKUP_TYPE = 'XLA_MERGE_MATCHING_TYPE' JOIN XLA_LOOKUPS L11 ON LTB.ACCOUNTING_CLASS_CODE = L11.LOOKUP_CODE
AND L11.LOOKUP_TYPE = 'XLA_ACCOUNTING_CLASS' JOIN XLA_LOOKUPS L12 ON 'A' = L12.LOOKUP_CODE
AND L12.LOOKUP_TYPE = 'XLA_ASSIGN_FLEX_MODE' JOIN XLA_LOOKUPS L13 ON XLD.LINE_DEFINITION_OWNER_CODE = L13.LOOKUP_CODE
AND L13.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
WHERE XAD.FLEXFIELD_SEGMENT_CODE = 'ALL'