View: PA_CAPITAL_EVENTS_V

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

View Text

SELECT E.ROWID ROW_ID
, E.CAPITAL_EVENT_ID
, E.PROJECT_ID
, E.CAPITAL_EVENT_NUMBER
, E.EVENT_TYPE
, E.EVENT_NAME
, E.ASSET_ALLOCATION_METHOD ASSET_ALLOC_METHOD
, L.MEANING
, E.EVENT_PERIOD
, E.LAST_UPDATE_DATE
, E.LAST_UPDATED_BY
, E.CREATION_DATE
, E.CREATED_BY
, E.LAST_UPDATE_LOGIN
, E.REQUEST_ID
, E.PROGRAM_APPLICATION_ID
, E.PROGRAM_ID
, E.PROGRAM_UPDATE_DATE
FROM PA_CAPITAL_EVENTS E
, PA_LOOKUPS L
WHERE E.ASSET_ALLOCATION_METHOD = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'ASSET_ALLOCATION_METHOD'

Columns