Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_XLA_CCDL_LINES_V |
SELECT CCDL.ACCT_EVENT_ID
, CCDL.EXPENDITURE_ITEM_ID
, CCDL.LINE_NUM
, IMP.SET_OF_BOOKS_ID
, CCDL.LINE_TYPE
, CCDL.CC_DIST_LINE_ID
, DECODE(NVL(CCDL.ACCT_SOURCE_CODE
, 'UPG')
, 'PA'
, DECODE(CCDL.DIST_LINE_ID_REVERSED
, NULL
, NULL
, CCDL.DIST_LINE_ID_REVERSED)
, NULL)
, DECODE(CCDL.DIST_LINE_ID_REVERSED
, NULL
, 'N'
, DECODE(CCDL_ORIG.EXPENDITURE_ITEM_ID
, CCDL.EXPENDITURE_ITEM_ID
, 'Y'
, 'N'))
, CCDL.CROSS_CHARGE_CODE
, CCDL.REFERENCE_1
, CCDL.REFERENCE_2
, CCDL.REFERENCE_3
, CCDL.DENOM_TP_CURRENCY_CODE
, DECODE(NVL(CCDL.ACCT_SOURCE_CODE
, 'UPG')
, 'PA'
, DECODE(CCDL_ORIG.EXPENDITURE_ITEM_ID
, CCDL.EXPENDITURE_ITEM_ID
, CCDL_ORIG.LINE_NUM)
, NULL)
, DECODE(CCDL.LINE_TYPE
, 'BL'
, CCDL.DR_CODE_COMBINATION_ID
, NULL)
, DECODE(CCDL.LINE_TYPE
, 'BL'
, CCDL.CR_CODE_COMBINATION_ID
, NULL)
, DECODE(CCDL.LINE_TYPE
, 'PC'
, CCDL.DR_CODE_COMBINATION_ID
, NULL)
, DECODE(CCDL.LINE_TYPE
, 'PC'
, CCDL.CR_CODE_COMBINATION_ID
, NULL)
, DECODE(CCDL.DIST_LINE_ID_REVERSED
, NULL
, 'Y'
, DECODE(CCDL_ORIG.EXPENDITURE_ITEM_ID
, CCDL.EXPENDITURE_ITEM_ID
, 'Y'
, 'N'))
, DECODE(CCDL.LINE_TYPE
, 'BL'
, DECODE(CCDL.DIST_LINE_ID_REVERSED
, NULL
, CCDL.DR_CODE_COMBINATION_ID
, DECODE(CCDL_ORIG.EXPENDITURE_ITEM_ID
, CCDL.EXPENDITURE_ITEM_ID
, CCDL.DR_CODE_COMBINATION_ID
, PA_XLA_INTERFACE_PKG.GET_SLA_CCID(275
, CCDL_ORIG.EXPENDITURE_ITEM_ID
, CCDL_ORIG.LINE_NUM
, CCDL_ORIG.LINE_TYPE
, 'DEBIT'
, IMP.SET_OF_BOOKS_ID)) )
, NULL)
, DECODE(CCDL.LINE_TYPE
, 'BL'
, DECODE(CCDL.DIST_LINE_ID_REVERSED
, NULL
, CCDL.CR_CODE_COMBINATION_ID
, DECODE(CCDL_ORIG.EXPENDITURE_ITEM_ID
, CCDL.EXPENDITURE_ITEM_ID
, CCDL.CR_CODE_COMBINATION_ID
, PA_XLA_INTERFACE_PKG.GET_SLA_CCID(275
, CCDL_ORIG.EXPENDITURE_ITEM_ID
, CCDL_ORIG.LINE_NUM
, CCDL_ORIG.LINE_TYPE
, 'CREDIT'
, IMP.SET_OF_BOOKS_ID)) )
, NULL)
, DECODE(CCDL.LINE_TYPE
, 'PC'
, DECODE(CCDL.DIST_LINE_ID_REVERSED
, NULL
, CCDL.DR_CODE_COMBINATION_ID
, DECODE(CCDL_ORIG.EXPENDITURE_ITEM_ID
, CCDL.EXPENDITURE_ITEM_ID
, CCDL.DR_CODE_COMBINATION_ID
, PA_XLA_INTERFACE_PKG.GET_SLA_CCID(275
, CCDL_ORIG.EXPENDITURE_ITEM_ID
, CCDL_ORIG.LINE_NUM
, CCDL_ORIG.LINE_TYPE
, 'DEBIT'
, IMP.SET_OF_BOOKS_ID)) )
, NULL)
, DECODE(CCDL.LINE_TYPE
, 'PC'
, DECODE(CCDL.DIST_LINE_ID_REVERSED
, NULL
, CCDL.CR_CODE_COMBINATION_ID
, DECODE(CCDL_ORIG.EXPENDITURE_ITEM_ID
, CCDL.EXPENDITURE_ITEM_ID
, CCDL.CR_CODE_COMBINATION_ID
, PA_XLA_INTERFACE_PKG.GET_SLA_CCID(275
, CCDL_ORIG.EXPENDITURE_ITEM_ID
, CCDL_ORIG.LINE_NUM
, CCDL_ORIG.LINE_TYPE
, 'CREDIT'
, IMP.SET_OF_BOOKS_ID)) )
, NULL)
, CCDL.DENOM_TRANSFER_PRICE
, CCDL.AMOUNT
, CCDL.ACCT_TP_EXCHANGE_RATE
, NVL(CCDL.ACCT_TP_RATE_DATE
, DECODE(IMP.DEFAULT_RATE_DATE_CODE
, 'P'
, CCDL.PA_DATE
, EI.EXPENDITURE_ITEM_DATE))
, CCDL.ACCT_TP_RATE_TYPE
, DECODE(NVL(CCDL.ACCT_SOURCE_CODE
, 'UPG')
, 'UPG'
, 'Y'
, 'N')
, DECODE(CCDL.LINE_TYPE
, 'BL'
, 'RECEIVER_COST'
, 'RECLASS_DESTINATION')
, DECODE(CCDL.LINE_TYPE
, 'BL'
, 'PROVIDER_COST'
, 'RECLASS_SOURCE')
FROM PA_CC_DIST_LINES_ALL CCDL
, PA_CC_DIST_LINES_ALL CCDL_ORIG
, PA_IMPLEMENTATIONS_ALL IMP
, PA_EXPENDITURE_ITEMS_ALL EI
WHERE IMP.ORG_ID = CCDL.ORG_ID
AND EI.EXPENDITURE_ITEM_ID=CCDL.EXPENDITURE_ITEM_ID
AND CCDL_ORIG.CC_DIST_LINE_ID(+) = CCDL.DIST_LINE_ID_REVERSED