[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 |
APPS.PA_PROJECT_TYPES_V