VIEW: WIP.WIP_LABOR_PERFORMANCE_RATES#

Source

View Text - Preformatted

select ORGANIZATION_ID ORGANIZATION_ID, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_ID RESOURCE_ID, EMPLOYEE_ID EMPLOYEE_ID, DATE_SEQUENCE DATE_SEQUENCE, SHIFT_NUM SHIFT_NUM, METRIC1_ATTRIBUTE1 METRIC1_ATTRIBUTE1, METRIC1_ATTRIBUTE2 METRIC1_ATTRIBUTE2, METRIC2_ATTRIBUTE1 METRIC2_ATTRIBUTE1, METRIC2_ATTRIBUTE2 METRIC2_ATTRIBUTE2, METRIC3_ATTRIBUTE1 METRIC3_ATTRIBUTE1, METRIC3_ATTRIBUTE2 METRIC3_ATTRIBUTE2, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_ID PROGRAM_ID, REQUEST_ID REQUEST_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "WIP"."WIP_LABOR_PERFORMANCE_RATES"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_ID RESOURCE_ID
, EMPLOYEE_ID EMPLOYEE_ID
, DATE_SEQUENCE DATE_SEQUENCE
, SHIFT_NUM SHIFT_NUM
, METRIC1_ATTRIBUTE1 METRIC1_ATTRIBUTE1
, METRIC1_ATTRIBUTE2 METRIC1_ATTRIBUTE2
, METRIC2_ATTRIBUTE1 METRIC2_ATTRIBUTE1
, METRIC2_ATTRIBUTE2 METRIC2_ATTRIBUTE2
, METRIC3_ATTRIBUTE1 METRIC3_ATTRIBUTE1
, METRIC3_ATTRIBUTE2 METRIC3_ATTRIBUTE2
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_ID PROGRAM_ID
, REQUEST_ID REQUEST_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "WIP"."WIP_LABOR_PERFORMANCE_RATES"