VIEW: APPS.XLA_PAD_INQ_LINES_AC_FVL

Source

View Text - Preformatted

SELECT al.application_id application_id ,al.amb_context_code amb_context_code ,al.product_rule_code product_rule_code ,prt.name product_rule_name ,al.product_rule_type_code product_rule_type_code ,l1.meaning product_rule_type_code_dsp ,al.line_definition_owner_code line_definition_owner_code ,l13.meaning line_definition_owner ,al.line_definition_code line_definition_code ,xld.name line_definition_name ,al.locking_status_flag locking_status_flag ,al.event_class_code event_class_code ,ec.name event_class_name ,al.event_type_code event_type_code ,et.name event_type_name ,al.accounting_line_code accounting_line_code ,lt.name accounting_line_name ,al.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 ,al.description_code description_code ,dp.name description_name ,al.description_type_code description_type_code ,l3.meaning description_type_code_dsp ,ac.analytical_criterion_code analytical_criterion_code ,ac.analytical_criterion_type_code analytical_criterion_type_code ,al.segment_rule_code segment_rule_code ,al.segment_rule_name segment_rule_name ,al.segment_rule_type_code segment_rule_type_code ,al.segment_rule_type_code_dsp segment_rule_type_code_dsp ,al.flexfield_assign_mode flexfield_assign_mode ,al.accounting_coa_id accounting_coa_id ,al.accounting_coa_name accounting_coa_name ,al.flexfield_segment_code flexfield_segment_code ,al.flexfield_segment_name flexfield_segment_name ,al.creation_date creation_date ,al.created_by created_by ,al.last_update_date last_update_date ,al.last_update_login last_update_login ,al.last_updated_by last_updated_by FROM XLA_PAD_INQ_LINES_SUB_FVL al ,xla_line_definitions_tl xld ,xla_product_rules_tl prt ,xla_event_classes_tl ec ,xla_event_types_tl et ,xla_acct_line_types_tl lt ,xla_acct_line_types_b ltb ,xla_descriptions_tl dp ,xla_line_defn_ac_assgns ac ,xla_lookups l1 ,xla_lookups l2 ,xla_lookups l3 ,xla_lookups l7 ,xla_lookups l8 ,xla_lookups l9 ,xla_lookups l10 ,xla_lookups l11 ,xla_lookups l13 WHERE al.application_id = prt.application_id AND al.amb_context_code = prt.amb_context_code AND al.product_rule_type_code = prt.product_rule_type_code AND al.product_rule_code = prt.product_rule_code AND prt.language = USERENV('LANG') AND al.application_id = xld.application_id AND al.amb_context_code = xld.amb_context_code AND al.event_class_code = xld.event_class_code AND al.event_type_code = xld.event_type_code AND al.line_definition_owner_code = xld.line_definition_owner_code AND al.line_definition_code = xld.line_definition_code AND xld.language = USERENV('LANG') AND al.application_id = ec.application_id AND al.event_class_code = ec.event_class_code AND ec.language = USERENV('LANG') AND al.application_id = et.application_id AND al.event_class_code = et.event_class_code AND al.event_type_code = et.event_type_code AND et.language = USERENV('LANG') AND al.application_id = ltb.application_id AND al.amb_context_code = ltb.amb_context_code AND al.event_class_code = ltb.event_class_code AND al.accounting_line_type_code = ltb.accounting_line_type_code AND al.accounting_line_code = ltb.accounting_line_code AND al.application_id = lt.application_id AND al.amb_context_code = lt.amb_context_code AND al.event_class_code = lt.event_class_code AND al.accounting_line_type_code = lt.accounting_line_type_code AND al.accounting_line_code = lt.accounting_line_code AND lt.language = USERENV('LANG') AND al.application_id = dp.application_id(+) AND al.amb_context_code = dp.amb_context_code(+) AND al.description_type_code = dp.description_type_code(+) AND al.description_code = dp.description_code(+) AND dp.language(+) = USERENV('LANG') AND al.application_id = ac.application_id AND al.amb_context_code = ac.amb_context_code AND al.line_definition_owner_code = ac.line_definition_owner_code AND al.line_definition_code = ac.line_definition_code AND al.event_class_code = ac.event_class_code AND al.event_type_code = ac.event_type_code AND al.accounting_line_type_code = ac.accounting_line_type_code AND al.accounting_line_code = ac.accounting_line_code AND al.product_rule_type_code = l1.lookup_code AND l1.lookup_type = 'XLA_OWNER_TYPE' AND al.accounting_line_type_code = l2.lookup_code AND l2.lookup_type = 'XLA_OWNER_TYPE' AND al.description_type_code = l3.lookup_code(+) AND l3.lookup_type(+) = 'XLA_OWNER_TYPE' AND ltb.accounting_entry_type_code = l7.lookup_code AND l7.lookup_type = 'XLA_BALANCE_TYPE' AND ltb.natural_side_code = l8.lookup_code AND l8.lookup_type = 'XLA_ACCT_NATURAL_SIDE' AND ltb.switch_side_flag = l9.lookup_code AND l9.lookup_type = 'XLA_YES_NO' AND ltb.merge_duplicate_code = l10.lookup_code AND l10.lookup_type = 'XLA_MERGE_MATCHING_TYPE' AND ltb.accounting_class_code = l11.lookup_code AND l11.lookup_type = 'XLA_ACCOUNTING_CLASS' AND xld.line_definition_owner_code = l13.lookup_code AND l13.lookup_type = 'XLA_OWNER_TYPE'

View Text - HTML Formatted

SELECT AL.APPLICATION_ID APPLICATION_ID
, AL.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, AL.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, PRT.NAME PRODUCT_RULE_NAME
, AL.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, L1.MEANING PRODUCT_RULE_TYPE_CODE_DSP
, AL.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, L13.MEANING LINE_DEFINITION_OWNER
, AL.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XLD.NAME LINE_DEFINITION_NAME
, AL.LOCKING_STATUS_FLAG LOCKING_STATUS_FLAG
, AL.EVENT_CLASS_CODE EVENT_CLASS_CODE
, EC.NAME EVENT_CLASS_NAME
, AL.EVENT_TYPE_CODE EVENT_TYPE_CODE
, ET.NAME EVENT_TYPE_NAME
, AL.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, LT.NAME ACCOUNTING_LINE_NAME
, AL.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
, AL.DESCRIPTION_CODE DESCRIPTION_CODE
, DP.NAME DESCRIPTION_NAME
, AL.DESCRIPTION_TYPE_CODE DESCRIPTION_TYPE_CODE
, L3.MEANING DESCRIPTION_TYPE_CODE_DSP
, AC.ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE
, AC.ANALYTICAL_CRITERION_TYPE_CODE ANALYTICAL_CRITERION_TYPE_CODE
, AL.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, AL.SEGMENT_RULE_NAME SEGMENT_RULE_NAME
, AL.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, AL.SEGMENT_RULE_TYPE_CODE_DSP SEGMENT_RULE_TYPE_CODE_DSP
, AL.FLEXFIELD_ASSIGN_MODE FLEXFIELD_ASSIGN_MODE
, AL.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, AL.ACCOUNTING_COA_NAME ACCOUNTING_COA_NAME
, AL.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, AL.FLEXFIELD_SEGMENT_NAME FLEXFIELD_SEGMENT_NAME
, AL.CREATION_DATE CREATION_DATE
, AL.CREATED_BY CREATED_BY
, AL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AL.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_PAD_INQ_LINES_SUB_FVL AL
, XLA_LINE_DEFINITIONS_TL XLD
, XLA_PRODUCT_RULES_TL PRT
, XLA_EVENT_CLASSES_TL EC
, XLA_EVENT_TYPES_TL ET
, XLA_ACCT_LINE_TYPES_TL LT
, XLA_ACCT_LINE_TYPES_B LTB
, XLA_DESCRIPTIONS_TL DP
, XLA_LINE_DEFN_AC_ASSGNS AC
, XLA_LOOKUPS L1
, XLA_LOOKUPS L2
, XLA_LOOKUPS L3
, XLA_LOOKUPS L7
, XLA_LOOKUPS L8
, XLA_LOOKUPS L9
, XLA_LOOKUPS L10
, XLA_LOOKUPS L11
, XLA_LOOKUPS L13
WHERE AL.APPLICATION_ID = PRT.APPLICATION_ID
AND AL.AMB_CONTEXT_CODE = PRT.AMB_CONTEXT_CODE
AND AL.PRODUCT_RULE_TYPE_CODE = PRT.PRODUCT_RULE_TYPE_CODE
AND AL.PRODUCT_RULE_CODE = PRT.PRODUCT_RULE_CODE
AND PRT.LANGUAGE = USERENV('LANG')
AND AL.APPLICATION_ID = XLD.APPLICATION_ID
AND AL.AMB_CONTEXT_CODE = XLD.AMB_CONTEXT_CODE
AND AL.EVENT_CLASS_CODE = XLD.EVENT_CLASS_CODE
AND AL.EVENT_TYPE_CODE = XLD.EVENT_TYPE_CODE
AND AL.LINE_DEFINITION_OWNER_CODE = XLD.LINE_DEFINITION_OWNER_CODE
AND AL.LINE_DEFINITION_CODE = XLD.LINE_DEFINITION_CODE
AND XLD.LANGUAGE = USERENV('LANG')
AND AL.APPLICATION_ID = EC.APPLICATION_ID
AND AL.EVENT_CLASS_CODE = EC.EVENT_CLASS_CODE
AND EC.LANGUAGE = USERENV('LANG')
AND AL.APPLICATION_ID = ET.APPLICATION_ID
AND AL.EVENT_CLASS_CODE = ET.EVENT_CLASS_CODE
AND AL.EVENT_TYPE_CODE = ET.EVENT_TYPE_CODE
AND ET.LANGUAGE = USERENV('LANG')
AND AL.APPLICATION_ID = LTB.APPLICATION_ID
AND AL.AMB_CONTEXT_CODE = LTB.AMB_CONTEXT_CODE
AND AL.EVENT_CLASS_CODE = LTB.EVENT_CLASS_CODE
AND AL.ACCOUNTING_LINE_TYPE_CODE = LTB.ACCOUNTING_LINE_TYPE_CODE
AND AL.ACCOUNTING_LINE_CODE = LTB.ACCOUNTING_LINE_CODE
AND AL.APPLICATION_ID = LT.APPLICATION_ID
AND AL.AMB_CONTEXT_CODE = LT.AMB_CONTEXT_CODE
AND AL.EVENT_CLASS_CODE = LT.EVENT_CLASS_CODE
AND AL.ACCOUNTING_LINE_TYPE_CODE = LT.ACCOUNTING_LINE_TYPE_CODE
AND AL.ACCOUNTING_LINE_CODE = LT.ACCOUNTING_LINE_CODE
AND LT.LANGUAGE = USERENV('LANG')
AND AL.APPLICATION_ID = DP.APPLICATION_ID(+)
AND AL.AMB_CONTEXT_CODE = DP.AMB_CONTEXT_CODE(+)
AND AL.DESCRIPTION_TYPE_CODE = DP.DESCRIPTION_TYPE_CODE(+)
AND AL.DESCRIPTION_CODE = DP.DESCRIPTION_CODE(+)
AND DP.LANGUAGE(+) = USERENV('LANG')
AND AL.APPLICATION_ID = AC.APPLICATION_ID
AND AL.AMB_CONTEXT_CODE = AC.AMB_CONTEXT_CODE
AND AL.LINE_DEFINITION_OWNER_CODE = AC.LINE_DEFINITION_OWNER_CODE
AND AL.LINE_DEFINITION_CODE = AC.LINE_DEFINITION_CODE
AND AL.EVENT_CLASS_CODE = AC.EVENT_CLASS_CODE
AND AL.EVENT_TYPE_CODE = AC.EVENT_TYPE_CODE
AND AL.ACCOUNTING_LINE_TYPE_CODE = AC.ACCOUNTING_LINE_TYPE_CODE
AND AL.ACCOUNTING_LINE_CODE = AC.ACCOUNTING_LINE_CODE
AND AL.PRODUCT_RULE_TYPE_CODE = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND AL.ACCOUNTING_LINE_TYPE_CODE = L2.LOOKUP_CODE
AND L2.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND AL.DESCRIPTION_TYPE_CODE = L3.LOOKUP_CODE(+)
AND L3.LOOKUP_TYPE(+) = 'XLA_OWNER_TYPE'
AND LTB.ACCOUNTING_ENTRY_TYPE_CODE = L7.LOOKUP_CODE
AND L7.LOOKUP_TYPE = 'XLA_BALANCE_TYPE'
AND LTB.NATURAL_SIDE_CODE = L8.LOOKUP_CODE
AND L8.LOOKUP_TYPE = 'XLA_ACCT_NATURAL_SIDE'
AND LTB.SWITCH_SIDE_FLAG = L9.LOOKUP_CODE
AND L9.LOOKUP_TYPE = 'XLA_YES_NO'
AND LTB.MERGE_DUPLICATE_CODE = L10.LOOKUP_CODE
AND L10.LOOKUP_TYPE = 'XLA_MERGE_MATCHING_TYPE'
AND LTB.ACCOUNTING_CLASS_CODE = L11.LOOKUP_CODE
AND L11.LOOKUP_TYPE = 'XLA_ACCOUNTING_CLASS'
AND XLD.LINE_DEFINITION_OWNER_CODE = L13.LOOKUP_CODE
AND L13.LOOKUP_TYPE = 'XLA_OWNER_TYPE'