[Home] [Help]
View: PA_PROJECT_TYPES_V
View Text
SELECT PT.ORG_ID
, PT.PROJECT_TYPE_ID
, PT.PROJECT_TYPE
, PT.DESCRIPTION
, CLASS.MEANING
, PT.PROJECT_TYPE_CLASS_CODE
, PT.START_DATE_ACTIVE
, PT.END_DATE_ACTIVE
, PT.CC_PRVDR_FLAG
FROM PA_LOOKUPS CLASS
, PA_PROJECT_TYPES PT
WHERE PT.PROJECT_TYPE_CLASS_CODE = CLASS.LOOKUP_CODE
AND CLASS.LOOKUP_TYPE = 'PROJECT TYPE CLASS'
AND CLASS.PREDEFINED_FLAG = DECODE ( PA_INSTALL.IS_BILLING_LICENSED()
, 'N'
, 'C'
, CLASS.PREDEFINED_FLAG)
Columns
Name |
ORG_ID |
PROJECT_TYPE_ID |
PROJECT_TYPE |
DESCRIPTION |
PROJECT_TYPE_CLASS_M |
PROJECT_TYPE_CLASS_CODE |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
CC_PRVDR_FLAG |