View: PA_CLASS_CATEGORIES_V

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

View Text

SELECT PCC.CLASS_CATEGORY
, PCC.DESCRIPTION
, DECODE(PCC.PICK_ONE_CODE_ONLY_FLAG
, 'Y'
, ' * '
, 'N'
, ' '
, ' ') PICK_ONE_CODE_ONLY_FLAG1
, PCC.AUTOACCOUNTING_FLAG
, PICK_ONE_CODE_ONLY_FLAG
, PCC.OBJECT_TYPE
, PCC.ALLOW_PERCENT_FLAG
, PCC.TOTAL_100_PERCENT_FLAG
, PCC.ALL_TYPES_VALID_FLAG
FROM PA_PROJECT_CLASSES PPC
, PA_CLASS_CATEGORIES PCC
WHERE PPC.CLASS_CATEGORY(+) = PCC.CLASS_CATEGORY
AND TRUNC(SYSDATE) BETWEEN PCC.START_DATE_ACTIVE
AND NVL(PCC.END_DATE_ACTIVE
, SYSDATE) GROUP BY PCC.CLASS_CATEGORY
, PCC.DESCRIPTION
, PCC.PICK_ONE_CODE_ONLY_FLAG
, PCC.MANDATORY_FLAG
, PCC.AUTOACCOUNTING_FLAG
, PCC.OBJECT_TYPE
, PCC.ALLOW_PERCENT_FLAG
, PCC.TOTAL_100_PERCENT_FLAG
, PCC.ALL_TYPES_VALID_FLAG ORDER BY PCC.MANDATORY_FLAG DESC
, PCC.CLASS_CATEGORY

Columns