[Home] [Help]
View: 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
Name |
CLASS_CATEGORY |
OBJECT_TYPE |
OBJECT_TYPE_ID |
MANDATORY_FLAG |
AUTOACCOUNTING_FLAG |
PICK_ONE_CODE_ONLY_FLAG |
ALLOW_PERCENT_FLAG |
TOTAL_100_PERCENT_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
DESCRIPTION |