View: PA_VALID_CATEGORIES_V

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

View Text

SELECT VC.CLASS_CATEGORY
, CC.OBJECT_TYPE
, VC.OBJECT_TYPE_ID
, VC.MANDATORY_FLAG
, CC.AUTOACCOUNTING_FLAG
, CC.PICK_ONE_CODE_ONLY_FLAG
, CC.ALLOW_PERCENT_FLAG
, CC.TOTAL_100_PERCENT_FLAG
, CC.START_DATE_ACTIVE
, CC.END_DATE_ACTIVE
, CC.DESCRIPTION
FROM PA_CLASS_CATEGORIES CC
, PA_VALID_CATEGORIES VC
, PA_PROJECT_TYPES_ALL PPTA
WHERE VC.CLASS_CATEGORY = CC.CLASS_CATEGORY
AND TRUNC(SYSDATE) BETWEEN TRUNC(CC.START_DATE_ACTIVE)
AND TRUNC(NVL(CC.END_DATE_ACTIVE
, SYSDATE))
AND VC.OBJECT_TYPE_ID = PPTA.PROJECT_TYPE_ID UNION SELECT CC.CLASS_CATEGORY
, CC.OBJECT_TYPE
, PPTA.PROJECT_TYPE_ID
, CC.MANDATORY_FLAG
, CC.AUTOACCOUNTING_FLAG
, CC.PICK_ONE_CODE_ONLY_FLAG
, CC.ALLOW_PERCENT_FLAG
, CC.TOTAL_100_PERCENT_FLAG
, CC.START_DATE_ACTIVE
, CC.END_DATE_ACTIVE
, CC.DESCRIPTION
FROM PA_CLASS_CATEGORIES CC
, PA_PROJECT_TYPES_ALL PPTA
WHERE CC.OBJECT_TYPE = 'PA_PROJECTS'
AND CC.ALL_TYPES_VALID_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(CC.START_DATE_ACTIVE)
AND TRUNC(NVL(CC.END_DATE_ACTIVE
, SYSDATE))
AND NOT EXISTS (SELECT 'Y'
FROM PA_VALID_CATEGORIES VC
WHERE VC.CLASS_CATEGORY = CC.CLASS_CATEGORY
AND VC.OBJECT_TYPE_ID = PPTA.PROJECT_TYPE_ID)

Columns