View: XLA_PAD_INQ_LINES_SUB_FVL

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_PAD_INQ_LINES_SUB_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
, XAL.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, XAL.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XAL.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XPA.LOCKING_STATUS_FLAG LOCKING_STATUS_FLAG
, XJL.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XJL.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XJL.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XJL.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XJL.DESCRIPTION_CODE DESCRIPTION_CODE
, XJL.DESCRIPTION_TYPE_CODE DESCRIPTION_TYPE_CODE
, XAD.SEGMENT_RULE_CODE SEGMENT_RULE_CODE
, SRT.NAME SEGMENT_RULE_NAME
, XAD.SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_TYPE_CODE
, L5.MEANING SEGMENT_RULE_TYPE_CODE_DSP
, L12.MEANING FLEXFIELD_ASSIGN_MODE
, SRB.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_JLT_ASSGNS XJL
, XLA_AAD_LINE_DEFN_ASSGNS XAL
, XLA_PROD_ACCT_HEADERS XPA
, XLA_LINE_DEFN_ADR_ASSGNS XAD
, XLA_SEG_RULES_TL SRT
, XLA_SEG_RULES_B SRB
, XLA_LOOKUPS L5
, FND_ID_FLEX_STRUCTURES_V FF
, XLA_LOOKUPS L6
, XLA_LOOKUPS L12
WHERE 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
AND 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
AND 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
AND XAD.FLEXFIELD_SEGMENT_CODE = 'ALL'
AND XAD.APPLICATION_ID = SRB.APPLICATION_ID
AND XAD.AMB_CONTEXT_CODE = SRB.AMB_CONTEXT_CODE
AND XAD.SEGMENT_RULE_TYPE_CODE = SRB.SEGMENT_RULE_TYPE_CODE
AND XAD.SEGMENT_RULE_CODE = SRB.SEGMENT_RULE_CODE
AND SRB.APPLICATION_ID = SRT.APPLICATION_ID
AND SRB.AMB_CONTEXT_CODE = SRT.AMB_CONTEXT_CODE
AND SRB.SEGMENT_RULE_TYPE_CODE = SRT.SEGMENT_RULE_TYPE_CODE
AND SRB.SEGMENT_RULE_CODE = SRT.SEGMENT_RULE_CODE
AND SRT.LANGUAGE = USERENV('LANG')
AND L5.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND XAD.SEGMENT_RULE_TYPE_CODE = L5.LOOKUP_CODE
AND SRB.ACCOUNTING_COA_ID = FF.ID_FLEX_NUM(+)
AND FF.ID_FLEX_CODE(+) = 'GL#'
AND FF.APPLICATION_ID(+) = 101
AND XAD.FLEXFIELD_SEGMENT_CODE = L6.LOOKUP_CODE
AND L6.LOOKUP_TYPE = 'XLA_FLEXFIELD_SEGMENTS_ALL' AND 'A' = L12.LOOKUP_CODE AND L12.LOOKUP_TYPE = 'XLA_ASSIGN_FLEX_MODE'
AND NOT EXISTS ( SELECT 'Y' FROM XLA_LINE_DEFN_ADR_ASSGNS PS WHERE XJL.APPLICATION_ID = PS.APPLICATION_ID
AND XJL.AMB_CONTEXT_CODE = PS.AMB_CONTEXT_CODE
AND XJL.EVENT_CLASS_CODE = PS.EVENT_CLASS_CODE
AND XJL.EVENT_TYPE_CODE = PS.EVENT_TYPE_CODE
AND XJL.LINE_DEFINITION_OWNER_CODE = PS.LINE_DEFINITION_OWNER_CODE
AND XJL.LINE_DEFINITION_CODE = PS.LINE_DEFINITION_CODE
AND XJL.ACCOUNTING_LINE_TYPE_CODE = PS.ACCOUNTING_LINE_TYPE_CODE
AND XJL.ACCOUNTING_LINE_CODE = PS.ACCOUNTING_LINE_CODE
AND PS.FLEXFIELD_SEGMENT_CODE != 'ALL') UNION /* JOURNAL ENTRY LINES WITH ONLY SEGMENT ADR */ SELECT XJL.ROWID ROW_ID
, XJL.APPLICATION_ID APPLICATION_ID
, XJL.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XPA.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, XPA.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, XAL.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XAL.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XPA.LOCKING_STATUS_FLAG LOCKING_STATUS_FLAG
, XJL.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XJL.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XJL.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XJL.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XJL.DESCRIPTION_CODE DESCRIPTION_CODE
, XJL.DESCRIPTION_TYPE_CODE DESCRIPTION_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
, XLA_LINE_DEFINITIONS_B XLD
, XLA_AAD_LINE_DEFN_ASSGNS XAL
, XLA_PROD_ACCT_HEADERS XPA
, FND_ID_FLEX_STRUCTURES_V FF
, XLA_LOOKUPS L12
WHERE 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
AND 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
AND 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
AND XLD.ACCOUNTING_COA_ID = FF.ID_FLEX_NUM(+)
AND FF.ID_FLEX_CODE(+) = 'GL#'
AND FF.APPLICATION_ID(+) = 101 AND 'S' = L12.LOOKUP_CODE AND L12.LOOKUP_TYPE = 'XLA_ASSIGN_FLEX_MODE'
AND 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.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
AND XAD.FLEXFIELD_SEGMENT_CODE != 'ALL')
AND NOT 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.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
AND XAD.FLEXFIELD_SEGMENT_CODE = 'ALL') UNION /* JOURNAL ENTRY LINES WITH ACCOUNTING FLEXFIELD
AND SEGMENT ADR */ SELECT XJL.ROWID ROW_ID
, XJL.APPLICATION_ID APPLICATION_ID
, XJL.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XAL.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, XAL.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, XAL.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XAL.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XPA.LOCKING_STATUS_FLAG LOCKING_STATUS_FLAG
, XJL.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XJL.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XJL.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XJL.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XJL.DESCRIPTION_CODE DESCRIPTION_CODE
, XJL.DESCRIPTION_TYPE_CODE DESCRIPTION_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
, XLA_LINE_DEFINITIONS_B XLD
, XLA_AAD_LINE_DEFN_ASSGNS XAL
, XLA_PROD_ACCT_HEADERS XPA
, FND_ID_FLEX_STRUCTURES_V FF
, FND_LOOKUPS L12
WHERE 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
AND 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
AND 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
AND XLD.ACCOUNTING_COA_ID = FF.ID_FLEX_NUM(+)
AND FF.ID_FLEX_CODE(+) = 'GL#'
AND FF.APPLICATION_ID(+) = 101 AND 'B' = L12.LOOKUP_CODE
AND L12.LOOKUP_TYPE = 'BOTH_ALL_NONE'
AND 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.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
AND XAD.FLEXFIELD_SEGMENT_CODE != 'ALL')
AND 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.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
AND XAD.FLEXFIELD_SEGMENT_CODE = 'ALL') UNION /* JOURNAL ENTRY LINES WITH NO SEGMENT RULES */ SELECT XJL.ROWID ROW_ID
, XJL.APPLICATION_ID APPLICATION_ID
, XJL.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XAL.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, XAL.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, XAL.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XAL.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XPA.LOCKING_STATUS_FLAG LOCKING_STATUS_FLAG
, XJL.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XJL.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XJL.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XJL.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XJL.DESCRIPTION_CODE DESCRIPTION_CODE
, XJL.DESCRIPTION_TYPE_CODE DESCRIPTION_TYPE_CODE
, NULL SEGMENT_RULE_CODE
, NULL SEGMENT_RULE_NAME
, NULL SEGMENT_RULE_TYPE_CODE
, NULL SEGMENT_RULE_TYPE_CODE_DSP
, NULL FLEXFIELD_ASSIGN_MODE
, TO_NUMBER(NULL) ACCOUNTING_COA_ID
, NULL 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
, XLA_AAD_LINE_DEFN_ASSGNS XAL
, XLA_PROD_ACCT_HEADERS XPA
WHERE 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
AND 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
AND NOT 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.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)

Columns