VIEW: APPS.PA_CE_TRANSACTIONS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'