View: XLA_PAD_INQ_LINES_SS_FVL

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

View Text

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')

Columns