VIEW: APPS.PA_RESOURCE_CLASS_RES_V

Source

View Text - Preformatted

SELECT cls.resource_class_id, cls.resource_class_code, cls.name, cls.description, def.enabled_flag FROM pa_resource_classes_vl cls, pa_plan_res_defaults def WHERE cls.resource_class_id = def.resource_class_id

View Text - HTML Formatted

SELECT CLS.RESOURCE_CLASS_ID
, CLS.RESOURCE_CLASS_CODE
, CLS.NAME
, CLS.DESCRIPTION
, DEF.ENABLED_FLAG
FROM PA_RESOURCE_CLASSES_VL CLS
, PA_PLAN_RES_DEFAULTS DEF
WHERE CLS.RESOURCE_CLASS_ID = DEF.RESOURCE_CLASS_ID