[Home] [Help]
View: PA_PROJECT_TYPE_CLASSES_V
View Text
SELECT L.LOOKUP_CODE
, L.MEANING
, L.START_DATE_ACTIVE
, L.END_DATE_ACTIVE
FROM PA_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'PROJECT TYPE CLASS'
AND L.PREDEFINED_FLAG = DECODE (PA_INSTALL.IS_BILLING_LICENSED()
, 'N'
, 'C'
, L.PREDEFINED_FLAG)
Columns
Name |
PROJECT_TYPE_CLASS_CODE |
PROJECT_TYPE_CLASS_M |
START_DATE_ACTIVE |
END_DATE_ACTIVE |