DBA Data[Home] [Help]

VIEW: APPS.PAFV_REVENUE_CATEGORIES

Source

View Text - Preformatted

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
View Text - HTML Formatted

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