FND Design Data [Home] [Help]

View: PABV_EXPENDITURE_GROUPS

Product: PA - Projects
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.PABV_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
, PEG.ORG_ID
, PEG.LAST_UPDATE_DATE
, PEG.LAST_UPDATED_BY
, PEG.CREATION_DATE
, PEG.CREATED_BY
FROM PA_EXPENDITURE_GROUPS_ALL PEG
, PA_SYSTEM_LINKAGES PSL
WHERE PEG.SYSTEM_LINKAGE_FUNCTION = PSL.FUNCTION AND '_SEC:PEG.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
EXPENDITURE_GROUP
"_LA:STATUS"
DESCRIPTION
SYSTEM_LINKAGE_FUNCTION
EXPENDITURE_ENDING_DATE
CONTROL_COUNT
CONTROL_TOTAL_AMOUNT
TRANSACTION_SOURCE
ORG_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY