eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_XLA_CDL_LINES_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_XLA_CDL_LINES_V

View Text

SELECT CDL.ACCT_EVENT_ID
, CDL.EXPENDITURE_ITEM_ID
, CDL.LINE_NUM
, IMP.SET_OF_BOOKS_ID
, DECODE(NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'UPG'
, DECODE (CDL.LINE_TYPE
, 'R'
, 'Y'
, 'N')
, 'PA'
, DECODE(CDL.LINE_NUM_REVERSED
, NULL
, 'N'
, 'Y')
, 'N')
, TO_NUMBER (DECODE(NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'PA'
, DECODE(CDL.LINE_NUM_REVERSED
, NULL
, NULL
, CDL.LINE_NUM_REVERSED)
, NULL) )
, CDL.LINE_TYPE
, CDL.DENOM_CURRENCY_CODE
, DECODE(CDL.LINE_TYPE
, 'C'
, -1 * CDL.DENOM_RAW_COST
, CDL.DENOM_RAW_COST)
, DECODE(CDL.LINE_TYPE
, 'C'
, -1 * CDL.DENOM_RAW_COST
, 'D'
, CDL.DENOM_RAW_COST
, CDL.DENOM_BURDENED_COST)
, DECODE(CDL.LINE_TYPE
, 'C'
, -1 * CDL.ACCT_RAW_COST
, CDL.ACCT_RAW_COST)
, DECODE(CDL.LINE_TYPE
, 'C'
, -1 * CDL.ACCT_RAW_COST
, 'D'
, CDL.ACCT_RAW_COST
, CDL.ACCT_BURDENED_COST)
, CDL.ACCT_EXCHANGE_RATE
, CDL.ACCT_RATE_TYPE
, CDL.ACCT_RATE_DATE
, CDL.DR_CODE_COMBINATION_ID
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'VI'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'ER'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, CDL.CR_CODE_COMBINATION_ID)
, DECODE( NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'UPG'
, DECODE ( CDL.LINE_TYPE
, 'R'
, DECODE (EI.ADJUSTED_EXPENDITURE_ITEM_ID
, NULL
, 'Y'
, 'N')
, 'N')
, 'EXT'
, 'N'
, 'PA'
, DECODE(CDL.PARENT_LINE_NUM
, NULL
, 'Y'
, 'N')
, 'N') ALLOW_OVERRIDE_CCID_FLAG
, DECODE(NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'UPG'
, CDL.DR_CODE_COMBINATION_ID
, 'EXT'
, CDL.DR_CODE_COMBINATION_ID
, 'PA'
, DECODE( NVL(CDL.LINE_NUM_REVERSED
, CDL.PARENT_LINE_NUM)
, NULL
, CDL.DR_CODE_COMBINATION_ID
, DECODE(CDL.PARENT_LINE_NUM
, NULL
, CDL.DR_CODE_COMBINATION_ID
, PA_XLA_INTERFACE_PKG.GET_SLA_CCID( 275
, EI.ADJUSTED_EXPENDITURE_ITEM_ID
, CDL.PARENT_LINE_NUM
, CDL.LINE_TYPE
, 'DEBIT'
, IMP.SET_OF_BOOKS_ID ) ) )
, PA_XLA_INTERFACE_PKG.GET_SLA_CCID( DECODE( CDL.ACCT_SOURCE_CODE
, 'AP_INV'
, 200
, 'AP_PAY'
, 200
, 'AP_APP'
, 200
, 'INV'
, 707
, 'WIP'
, 707
, 'RCV'
, 707
, NULL )
, DECODE( CDL.ACCT_SOURCE_CODE
, 'AP_INV'
, EI.DOCUMENT_DISTRIBUTION_ID
, 'AP_PAY'
, CDL.SYSTEM_REFERENCE5
, 'AP_APP'
, CDL.SYSTEM_REFERENCE5
, 'INV'
, CDL.SYSTEM_REFERENCE5
, 'WIP'
, CDL.SYSTEM_REFERENCE5
, 'RCV'
, CDL.SYSTEM_REFERENCE5
, NULL )
, NULL
, DECODE (CDL.ACCT_SOURCE_CODE
, 'AP_PAY'
, 'AP_PMT_DIST'
, 'AP_INV'
, 'AP_INV_DIST'
, 'AP_APP'
, 'AP_PREPAY'
, 'RCV'
, 'RCV_RECEIVING_SUB_LEDGER'
, 'INV'
, 'MTL_TRANSACTION_ACCOUNTS'
, 'WIP'
, 'WIP_TRANSACTION_ACCOUNTS'
, CDL.LINE_TYPE )
, 'DEBIT'
, IMP.SET_OF_BOOKS_ID ) ) ADJ_COST_CCID
, DECODE(NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'UPG'
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'VI'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'ER'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, CDL.CR_CODE_COMBINATION_ID)
, 'EXT'
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'VI'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'ER'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, CDL.CR_CODE_COMBINATION_ID)
, 'RCV'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'AP_INV'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'AP_PAY'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'AP_APP'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'PA'
, DECODE( NVL(CDL.LINE_NUM_REVERSED
, CDL.PARENT_LINE_NUM)
, NULL
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'VI'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'ER'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, CDL.CR_CODE_COMBINATION_ID)
, DECODE(CDL.PARENT_LINE_NUM
, NULL
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'VI'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, 'ER'
, NVL(CDL.CR_CODE_COMBINATION_ID
, IMP.DEF_SUPPLIER_COST_CR_CCID)
, CDL.CR_CODE_COMBINATION_ID)
, PA_XLA_INTERFACE_PKG.GET_SLA_CCID( 275
, EI.ADJUSTED_EXPENDITURE_ITEM_ID
, CDL.PARENT_LINE_NUM
, CDL.LINE_TYPE
, 'CREDIT'
, IMP.SET_OF_BOOKS_ID ) ) )
, PA_XLA_INTERFACE_PKG.GET_SLA_CCID( DECODE( NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'INV'
, 707
, 'WIP'
, 707
, NULL )
, DECODE( NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'INV'
, CDL.SYSTEM_REFERENCE4
, 'WIP'
, CDL.SYSTEM_REFERENCE4
, NULL )
, NULL
, DECODE (CDL.ACCT_SOURCE_CODE
, 'RCV'
, 'RCV_RECEIVING_SUB_LEDGER'
, 'INV'
, 'MTL_TRANSACTION_ACCOUNTS'
, 'WIP'
, 'WIP_TRANSACTION_ACCOUNTS'
, CDL.LINE_TYPE )
, 'CREDIT'
, IMP.SET_OF_BOOKS_ID ) ) ADJ_COST_CLEARING_CCID
, CDL.PROJECT_ID
, CDL.TASK_ID
, CDL.WORK_TYPE_ID
, CDL.BILLABLE_FLAG
, DECODE(NVL(CDL.ACCT_SOURCE_CODE
, 'UPG')
, 'UPG'
, DECODE ( CDL.LINE_TYPE
, 'R'
, 'Y'
, 'N')
, 'N')
, 'COST'
, 'COST_CLEARING'
, CDL.BUDGET_CCID
, (SELECT DECODE(PBL.BC_EVENT_ID
, NULL
, 'Y'
, 'N')
FROM PA_BUDGET_LINES PBL
WHERE PBL.BUDGET_LINE_ID = CDL.BUDGET_LINE_ID)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 275
, 'PA_BUDGET_ENC'
, 'BUDGETS'
, CDL.BUDGET_LINE_ID
, CDL.BUDGET_VERSION_ID
, NULL
, NULL
, PA_FUNDS_CONTROL_UTILS.GET_BDGT_LINK(CDL.PROJECT_ID
, 'STD')
, CDL.ENCUMBRANCE_AMOUNT
, PA_FUNDS_CONTROL_UTILS.GET_ENCUM_TYPE_ID(CDL.PROJECT_ID
, 'STD')
, PA_FUNDS_CONTROL_UTILS.GET_ENCUM_TYPE_ID(CDL.PROJECT_ID
, 'STD')
, NULL
, DECODE(NVL(EI.PO_LINE_ID
, -99)
, -99
, 'N'
, 'Y')
, CDL.LIQUIDATE_ENCUM_FLAG
, 'N'
FROM PA_EXPENDITURE_ITEMS_ALL EI
, PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_IMPLEMENTATIONS_ALL IMP
WHERE EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
AND IMP.ORG_ID = CDL.ORG_ID UNION ALL SELECT BCCOM.BC_EVENT_ID
, BCCOM.EXP_ITEM_ID
, BCCOM.BC_COMMITMENT_ID
, BCCOM.SET_OF_BOOKS_ID
, 'N'
, NULL
, 'E'
, EI.ACCT_CURRENCY_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, NULL
, NULL
, BCCOM.PROJECT_ID
, BCCOM.TASK_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, BCCOM.BUDGET_CCID
, PA_FUNDS_CONTROL_UTILS.GET_SLA_NOTUPGRADED_FLAG( DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, 200
, 'PO'
, 201)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, 'AP_INVOICES'
, 'PO'
, DECODE(BCCOM.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, 'RELEASE'
, 'BLANKET'
, 'RELEASE'
, 'PURCHASE_ORDER'))
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, BCCOM.DOCUMENT_HEADER_ID
, 'PO'
, DECODE(BCCOM.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, BCCOM.DOCUMENT_HEADER_ID_2
, 'BLANKET'
, BCCOM.DOCUMENT_HEADER_ID_2
, BCCOM.DOCUMENT_HEADER_ID))
, BCCOM.DOCUMENT_DISTRIBUTION_ID
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, 'AP_INV_DIST'
, 'PO'
, 'PO_DISTRIBUTIONS_ALL')
, BCCOM.BUDGET_VERSION_ID
, BCCOM.BUDGET_LINE_ID)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, (DECODE(BCCOM.BURDEN_METHOD_CODE
, 'S'
, 'PA_AP_INV_BURDENED'
, 'D'
, 'PA_AP_INV_BURDEN'
, NULL))
, 'PO'
, (DECODE(BCCOM.BURDEN_METHOD_CODE
, 'S'
, 'PA_PO_BURDENED'
, 'D'
, 'PA_PO_BURDEN'
, NULL))
, NULL)
, NULL
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, 200
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, 'PA_AP_BURDEN'
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, 'AP_INVOICES'
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, BCCOM.DOCUMENT_DISTRIBUTION_ID
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, BCCOM.EXPENDITURE_TYPE
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, BCCOM.DOCUMENT_HEADER_ID
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, 201
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, 'PA_PO_BURDEN'
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, DECODE(BCCOM.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, 'RELEASE'
, 'BLANKET'
, 'RELEASE'
, 'PURCHASE_ORDER')
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, BCCOM.DOCUMENT_DISTRIBUTION_ID
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, BCCOM.EXPENDITURE_TYPE
, NULL)
, DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, DECODE(BCCOM.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, BCCOM.DOCUMENT_HEADER_ID_2
, 'BLANKET'
, BCCOM.DOCUMENT_HEADER_ID_2
, BCCOM.DOCUMENT_HEADER_ID)
, NULL)
, 275
, 'PA_BUDGET_ENC'
, 'BUDGETS'
, BCCOM.BUDGET_LINE_ID
, BCCOM.BUDGET_VERSION_ID
, NULL
, BCCOM.DOCUMENT_TYPE
, PA_FUNDS_CONTROL_UTILS.GET_BDGT_LINK(EI.PROJECT_ID
, 'STD')
, (-1*(NVL(BCCOM.ACCOUNTED_DR
, 0)-NVL(BCCOM.ACCOUNTED_CR
, 0)))
, (SELECT ENCT.ENCUMBRANCE_TYPE_ID
FROM GL_ENCUMBRANCE_TYPES ENCT
WHERE ENCT.ENCUMBRANCE_TYPE_KEY = DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, 'OBLIGATION'
, 'INVOICES'))
, PA_FUNDS_CONTROL_UTILS.GET_ENCUM_TYPE_ID(BCCOM.PROJECT_ID
, 'STD')
, DECODE(BCCOM.DOCUMENT_TYPE
, 'PO'
, DECODE(BCCOM.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, BCCOM.DOCUMENT_HEADER_ID_2
, 'BLANKET'
, BCCOM.DOCUMENT_HEADER_ID_2
, NULL)
, NULL)
, DECODE(NVL(EI.PO_LINE_ID
, -99)
, -99
, 'N'
, 'Y')
, NULL
, DECODE(BCCOM.DOCUMENT_TYPE
, 'AP'
, PA_FUNDS_CONTROL_UTILS.GET_AP_SLA_REVERSED_STATUS(BCCOM.DOCUMENT_HEADER_ID
, BCCOM.DOCUMENT_DISTRIBUTION_ID)
, 'N')
FROM PA_EXPENDITURE_ITEMS_ALL EI
, PA_BC_COMMITMENTS_ALL BCCOM
WHERE EI.EXPENDITURE_ITEM_ID = BCCOM.EXP_ITEM_ID

Columns

Name
EVENT_ID
EXPENDITURE_ITEM_ID
LINE_NUMBER
LEDGER_ID
REVERSING_LINE_FLAG
LINE_NUM_REVERSED
LINE_TYPE
ENTERED_CURRENCY_CODE
ENTERED_RAW_COST
ENTERED_BURDENED_COST
ACCT_RAW_COST
ACCT_BURDENED_COST
EXCHANGE_RATE
EXCHANGE_RATE_TYPE
EXCHANGE_RATE_DATE
COST_CCID
COST_CLEARING_CCID
ALLOW_OVERRIDE_CCID_FLAG
ADJ_COST_CCID
ADJ_COST_CLEARING_CCID
PROJECT_ID
TASK_ID
WORK_TYPE_ID
BILLABLE_FLAG
USE_ACT_UPG_ATTRIB_FLAG
ACTUAL_UPG_DR_ACCT_CLASS
ACTUAL_UPG_CR_ACCT_CLASS
BUDGET_CCID
USE_ENC_UPG_ATTRIB_FLAG
ENC_UPG_DR_ACCT_CLASS
ENC_UPG_CR_ACCT_CLASS
INVOICE_APPLICATION_ID
INVOICE_DISTRIBUTION_TYPE
INVOICE_ENTITY_CODE
INVOICE_FIRST_DIST_ID
INVOICE_SECOND_DIST_ID
INVOICE_FIRST_SYS_TRANS_ID
PO_APPLICATION_ID
PO_DISTRIBUTION_TYPE
PO_ENTITY_CODE
PO_FIRST_DIST_ID
PO_SECOND_DIST_ID
PO_FIRST_SYS_TRANS_ID
PA_APPLICATION_ID
PA_DISTRIBUTION_TYPE
PA_ENTITY_CODE
PA_FIRST_DIST_ID
PA_FIRST_SYS_TRANS_ID
PA_SECOND_DIST_ID
DOCUMENT_TYPE
ENC_ACCT_ENABLED
ENCUMBRANCE_AMOUNT
ENCUMBRANCE_TYPE_ID
PROJ_ENCUMBRANCE_TYPE_ID
PO_RELEASE_ID
CWK_RATE_BASED_TC_FLAG
LIQUIDATE_ENCUM_FLAG
ENC_JE_LINES_REVERSED_FLAG