MATERIALIZED VIEW: APPS.MSC_PHUB_RESOURCES_MV

Source

(SELECT "A4"."SR_INSTANCE_ID" "SR_INSTANCE_ID","A4"."ORGANIZATION_ID" "ORGANIZATION_ID","A4"."DEPARTMENT_ID" "DEPARTMENT_ID","A4"."DEPARTMENT_CODE" "DEPARTMENT_CODE","A4"."DEPARTMENT_DESCRIPTION" "DEPARTMENT_DESCRIPTION","A4"."DEPARTMENT_CLASS" "DEPARTMENT_CLASS","A4"."RESOURCE_ID" "RESOURCE_ID",NVL("A3"."GROUP_CODE",'-23453') "RESOURCE_GROUP_ID","A3"."GROUP_CODE" "RESOURCE_GROUP_CODE","A3"."DESCRIPTION" "RESOURCE_GROUP_DESCRIPTION","A4"."RESOURCE_CODE" "RESOURCE_NAME","A4"."RESOURCE_DESCRIPTION" "RESOURCE_DESCRIPTION","A4"."EFFICIENCY" "EFFICIENCY","A4"."UTILIZATION" "UTILIZATION","A4"."MIN_CAPACITY" "MIN_CAPACITY","A4"."MAX_CAPACITY" "MAX_CAPACITY","A4"."LINE_FLAG" "LINE_FLAG","A4"."MAX_RATE" "MAX_RATE","A4"."BATCHABLE_FLAG" "BATCHABLE_FLAG",NVL("A4"."BOTTLENECK_FLAG",2) "BOTTLENECK_FLAG","A4"."RESOURCE_TYPE" "RESOURCE_TYPE" FROM "MSC"."MSC_DEPARTMENT_RESOURCES" "A4","MSC"."MSC_RESOURCE_GROUPS" "A3" WHERE "A3"."SR_INSTANCE_ID"(+)="A4"."SR_INSTANCE_ID" AND "A3"."GROUP_CODE"(+)="A4"."RESOURCE_GROUP_NAME" AND "A4"."PLAN_ID"=(-1) AND "A4"."RESOURCE_ID"<>(-1)) UNION ALL  (SELECT DISTINCT "A2"."SR_INSTANCE_ID" "SR_INSTANCE_ID","A2"."ORGANIZATION_ID" "ORGANIZATION_ID",TO_NUMBER((-23453)) "DEPARTMENT_ID",TO_CHAR(NULL) "DEPARTMENT_CODE",TO_CHAR(NULL) "DEPARTMENT_DESCRIPTION",TO_CHAR(NULL) "DEPARTMENT_CLASS",TO_NUMBER((-23453)) "RESOURCE_ID",'-23453' "RESOURCE_GROUP_ID",TO_CHAR(NULL) "RESOURCE_GROUP_CODE",TO_CHAR(NULL) "RESOURCE_GROUP_DESCRIPTION",TO_CHAR(NULL) "RESOURCE_NAME",TO_CHAR(NULL) "RESOURCE_DESCRIPTION",NULL "EFFICIENCY",NULL "UTILIZATION",NULL "MIN_CAPACITY",NULL "MAX_CAPACITY",NULL "LINE_FLAG",NULL "MAX_RATE",NULL "BATCHABLE_FLAG",NULL "BOTTLENECK_FLAG",NULL "RESOURCE_TYPE" FROM "MSC"."MSC_INSTANCE_ORGS" "A2")