View: PABV_EXPENDITURES

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

View Text

SELECT PEA.EXPENDITURE_ID
, '_LA:EXPENDITURE_STATUS_CODE:PA_LOOKUPS:EXPENDITURE STATUS:MEANING'
, '_LA:EXPENDITURE_CLASS_CODE:PA_LOOKUPS:EXPENDITURE CLASS CODE:MEANING'
, PEA.DESCRIPTION
, PEA.CONTROL_TOTAL_AMOUNT
, PEA.EXPENDITURE_ENDING_DATE
, PEA.EXPENDITURE_GROUP
, PEA.INCURRED_BY_PERSON_ID
, PEA.INCURRED_BY_ORGANIZATION_ID
, ORG_ID /* OPERATING UNIT */
, PEA.ORIG_EXP_TXN_REFERENCE1
, PEA.ORIG_USER_EXP_TXN_REFERENCE
, PEA.VENDOR_ID
, PEA.ORIG_EXP_TXN_REFERENCE2
, PEA.ORIG_EXP_TXN_REFERENCE3
, PEA.OVERRIDING_APPROVER_PERSON_ID
, PEA.WF_STATUS_CODE
, PEA.TRANSFER_STATUS_CODE
, '_DF:PA:PA_EXPENDITURES_DESC_FLEX:PEA'
, PEA.LAST_UPDATE_DATE
, PEA.LAST_UPDATED_BY
, PEA.CREATION_DATE
, PEA.CREATED_BY
, PEA.USER_BATCH_NAME
FROM PA_EXPENDITURES_ALL PEA
WHERE '_SEC:PEA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns