VIEW: APPS.XLA_PAD_INQ_LINES_SS_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 ,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 ,xlt.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 ,null analytical_criterion_code ,null analytical_criterion_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 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_line_definitions_tl xlt ON xlt.application_id = xjl.application_id AND xlt.amb_context_code = xjl.amb_context_code AND xlt.event_class_code = xjl.event_class_code AND xlt.event_type_code = xjl.event_type_code AND xlt.line_definition_owner_code = xjl.line_definition_owner_code AND xlt.line_definition_code = xjl.line_definition_code AND xlt.language = USERENV('LANG') 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_definitions_b xld ON 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 LEFT OUTER JOIN fnd_id_flex_structures_v ff ON xld.accounting_coa_id = ff.id_flex_num AND ff.id_flex_code = 'GL#' AND ff.application_id = 101 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 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 'S' = 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 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.line_definition_owner_code = xad.line_definition_owner_code AND xjl.line_definition_code = xad.line_definition_code AND xjl.event_class_code = xad.event_class_code AND xjl.event_type_code = xad.event_type_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')

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
, 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
, XLT.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
, NULL ANALYTICAL_CRITERION_CODE
, NULL ANALYTICAL_CRITERION_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 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_LINE_DEFINITIONS_TL XLT ON XLT.APPLICATION_ID = XJL.APPLICATION_ID
AND XLT.AMB_CONTEXT_CODE = XJL.AMB_CONTEXT_CODE
AND XLT.EVENT_CLASS_CODE = XJL.EVENT_CLASS_CODE
AND XLT.EVENT_TYPE_CODE = XJL.EVENT_TYPE_CODE
AND XLT.LINE_DEFINITION_OWNER_CODE = XJL.LINE_DEFINITION_OWNER_CODE
AND XLT.LINE_DEFINITION_CODE = XJL.LINE_DEFINITION_CODE
AND XLT.LANGUAGE = USERENV('LANG') 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_DEFINITIONS_B XLD ON 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 LEFT OUTER JOIN FND_ID_FLEX_STRUCTURES_V FF ON XLD.ACCOUNTING_COA_ID = FF.ID_FLEX_NUM
AND FF.ID_FLEX_CODE = 'GL#'
AND FF.APPLICATION_ID = 101 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 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 'S' = 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 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.LINE_DEFINITION_OWNER_CODE = XAD.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = XAD.LINE_DEFINITION_CODE
AND XJL.EVENT_CLASS_CODE = XAD.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = XAD.EVENT_TYPE_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')