Product: | PA - Projects |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: |
![]() |
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