VIEW: WIP.WIP_WS_RES_SHORTAGE#

Source

View Text - Preformatted

select ORGANIZATION_ID ORGANIZATION_ID, WIP_ENTITY_ID WIP_ENTITY_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, RESOURCE_ID RESOURCE_ID, DEPARTMENT_ID DEPARTMENT_ID, DATE_REQUIRED DATE_REQUIRED, REQUIRED_QTY REQUIRED_QTY, QUANTITY_ISSUED QUANTITY_ISSUED, QUANTITY_OPEN QUANTITY_OPEN, RESOURCE_AVAIL RESOURCE_AVAIL, RESOURCE_PROJ_AVAIL RESOURCE_PROJ_AVAIL, RESOURCE_SHORTAGE RESOURCE_SHORTAGE, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PROGRAM_RUN_DATE PROGRAM_RUN_DATE from "WIP"."WIP_WS_RES_SHORTAGE"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, RESOURCE_ID RESOURCE_ID
, DEPARTMENT_ID DEPARTMENT_ID
, DATE_REQUIRED DATE_REQUIRED
, REQUIRED_QTY REQUIRED_QTY
, QUANTITY_ISSUED QUANTITY_ISSUED
, QUANTITY_OPEN QUANTITY_OPEN
, RESOURCE_AVAIL RESOURCE_AVAIL
, RESOURCE_PROJ_AVAIL RESOURCE_PROJ_AVAIL
, RESOURCE_SHORTAGE RESOURCE_SHORTAGE
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PROGRAM_RUN_DATE PROGRAM_RUN_DATE
FROM "WIP"."WIP_WS_RES_SHORTAGE"