CSE_WC_RESOURCES_V

Details

• Schema: FUSION

• Object owner: CSE

• Object type: VIEW

Columns

Name
ORGANIZATION_ID WORK_CENTER_ID WORK_CENTER_CODE WORK_CENTER_NAME RESOURCE_ID RESOURCE_CODE RESOURCE_NAME

Query

SQL_Statement

select wwc.organization_id organization_id, wwcr.work_center_id work_center_id, wwc.work_center_code work_center_code, wwc.work_center_name work_center_name, wwcr.resource_id resource_id, wr.resource_code resource_code, wr.resource_name resource_name from wis_wc_resources wwcr, wis_work_centers_vl wwc, wis_resources_vl wr where wwc.work_center_id = wwcr.work_center_id and wr.resource_id = wwcr.resource_id