VIEW: MSC.MSC_RESOURCES_F#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, PLAN_RUN_ID PLAN_RUN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_ID RESOURCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ANALYSIS_DATE ANALYSIS_DATE, AVAILABLE_HOURS AVAILABLE_HOURS, REQUIRED_HOURS REQUIRED_HOURS, SETUP_TIME_HRS SETUP_TIME_HRS, ORDER_QUANTITY ORDER_QUANTITY, RESOURCE_HOURS RESOURCE_HOURS, NO_OF_ORDERS NO_OF_ORDERS, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID, RESOURCE_COST RESOURCE_COST, RESOURCE_COST2 RESOURCE_COST2, AGGR_TYPE AGGR_TYPE, RESOURCE_GROUP RESOURCE_GROUP from "MSC"."MSC_RESOURCES_F"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, PLAN_RUN_ID PLAN_RUN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_ID RESOURCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ANALYSIS_DATE ANALYSIS_DATE
, AVAILABLE_HOURS AVAILABLE_HOURS
, REQUIRED_HOURS REQUIRED_HOURS
, SETUP_TIME_HRS SETUP_TIME_HRS
, ORDER_QUANTITY ORDER_QUANTITY
, RESOURCE_HOURS RESOURCE_HOURS
, NO_OF_ORDERS NO_OF_ORDERS
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
, RESOURCE_COST RESOURCE_COST
, RESOURCE_COST2 RESOURCE_COST2
, AGGR_TYPE AGGR_TYPE
, RESOURCE_GROUP RESOURCE_GROUP
FROM "MSC"."MSC_RESOURCES_F"