View: XLA_PAD_INQ_LINES_AC_FVL

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_PAD_INQ_LINES_AC_FVL

View Text

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'

Columns