VIEW: APPS.PA_VALID_CATEGORIES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)