View: PAFV_EXPENDITURE_GROUPS

Product:	PA - Projects
Description:	Business view to show information about the expenditure batches entered.
Implementation/DBA Data:	APPS.PAFV_EXPENDITURE_GROUPS

View Text

SELECT PEG.EXPENDITURE_GROUP
, '_LA:EXPENDITURE_GROUP_STATUS_CODE:PA_LOOKUPS:EXPENDITURE GROUP STATUS:MEANING'
, PEG.DESCRIPTION
, PSL.MEANING
, PEG.EXPENDITURE_ENDING_DATE
, CONTROL_COUNT
, CONTROL_TOTAL_AMOUNT
, PEG.TRANSACTION_SOURCE
, PTS.DESCRIPTION
, PEG.ORG_ID
, TL.NAME
, PEG.LAST_UPDATE_DATE
, PEG.LAST_UPDATED_BY
, PEG.CREATION_DATE
, PEG.CREATED_BY
FROM PA_EXPENDITURE_GROUPS_ALL PEG
, PA_SYSTEM_LINKAGES PSL
, PA_TRANSACTION_SOURCES PTS
, HR_ALL_ORGANIZATION_UNITS_TL TL
WHERE PEG.SYSTEM_LINKAGE_FUNCTION = PSL.FUNCTION
AND PEG.ORG_ID = TL.ORGANIZATION_ID
AND TL.LANGUAGE = USERENV('LANG')
AND PEG.TRANSACTION_SOURCE = PTS.TRANSACTION_SOURCE(+)
AND '_SEC:PEG.ORG_ID' IS NOT NULL WITH READ ONLY

Columns