FND Design Data [Home] [Help]

View: PA_CLASS_CATEGORIES_LOV_V

Product: PA - Projects
Description: This view displays all the implementation-defined values for class categories and class codes
Implementation/DBA Data: ViewAPPS.PA_CLASS_CATEGORIES_LOV_V
View Text

SELECT CLASS_CATEGORY
, CLASS_CODE
, DESCRIPTION
FROM PA_CLASS_CODES
WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns

Name
CLASS_CATEGORY
CODE
DESCRIPTION