[Home] [Help]
View: PA_CE_EXP_REPORTS_V
View Text
SELECT PT.PROJECT_ID
, PEI.DENOM_RAW_COST
, PEI.ACCT_RAW_COST
, PEI.DENOM_CURRENCY_CODE
, PEI.ACCT_CURRENCY_CODE
, PEI.EXPENDITURE_ITEM_DATE
, PEI.ORG_ID
, PEI.EXPENDITURE_ITEM_ID
, PEI.BILL_HOLD_FLAG
, PEI.TRANSACTION_SOURCE
FROM PA_EXPENDITURE_ITEMS_ALL PEI
, PA_TASKS PT
, PA_COST_DISTRIBUTION_LINES_ALL PCDL
WHERE PCDL.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
AND PCDL.TRANSFER_STATUS_CODE IN ('P'
, 'R')
AND PEI.SYSTEM_LINKAGE_FUNCTION = 'ER'
AND NVL(PEI.TRANSACTION_SOURCE
, 'NULL_TRX_SOURCE') <> 'AP EXPENSE'
AND PEI.TASK_ID = PT.TASK_ID
Columns
PROJECT_ID |
AMOUNT |
BASE_AMOUNT |
CURRENCY_CODE |
FUNCTIONAL_CURRENCY_CODE |
TRX_DATE |
ORG_ID |
EXPENDITURE_ITEM_ID |
BILL_HOLD_FLAG |
TRANSACTION_SOURCE |
Name |