View: PA_CE_TRANSACTIONS_V

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

View Text

SELECT T.PROJECT_ID
, EI.DENOM_RAW_COST
, EI.ACCT_RAW_COST
, EI.DENOM_CURRENCY_CODE
, EI.ACCT_CURRENCY_CODE
, E.EXPENDITURE_ENDING_DATE
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, 'L'
, 'OT'
, 'L'
, 'USG'
, 'U'
, 'PJ'
, 'M'
, '')
, EI.ORG_ID
, EI.EXPENDITURE_ITEM_ID
, E.EXPENDITURE_STATUS_CODE
, EI.EXPENDITURE_TYPE
, EI.EXPENDITURE_ITEM_DATE
, EI.QUANTITY
FROM PA_EXPENDITURES_ALL E
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_TASKS T
WHERE EI.EXPENDITURE_ID = E.EXPENDITURE_ID
AND EI.TASK_ID = T.TASK_ID
AND EI.SYSTEM_LINKAGE_FUNCTION IN ('ST'
, 'OT'
, 'USG'
, 'PJ')
AND NVL(EI.COST_DISTRIBUTED_FLAG
, 'N') = 'Y'

Columns