VIEW: APPS.PA_CAPITAL_EVENTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'