FND Design Data [Home] [Help]

View: PAFV_REVENUE_CATEGORIES

Product: PA - Projects
Description: Business view to show information about the revenue categories available.
Implementation/DBA Data: ViewAPPS.PAFV_REVENUE_CATEGORIES
View Text

SELECT PL.LOOKUP_CODE
, PL.DESCRIPTION
, PL.START_DATE_ACTIVE
, PL.END_DATE_ACTIVE
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.CREATION_DATE
, PL.CREATED_BY
FROM PA_LOOKUPS PL
WHERE PL.LOOKUP_TYPE = 'REVENUE CATEGORY' WITH READ ONLY

Columns

Name
REVENUE_CATEGORY
DESCRIPTION
START_EFFECTIVE_DATE
END_EFFECTIVE_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY