[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
| Name |
| PROJECT_ID |
| AMOUNT |
| BASE_AMOUNT |
| CURRENCY_CODE |
| FUNCTIONAL_CURRENCY_CODE |
| TRX_DATE |
| ORG_ID |
| EXPENDITURE_ITEM_ID |
| BILL_HOLD_FLAG |
| TRANSACTION_SOURCE |
APPS.PA_CE_EXP_REPORTS_V