VIEW: WIP.WIP_WS_COMP_SHORTAGE#

Source

View Text - Preformatted

select ORGANIZATION_ID ORGANIZATION_ID, WIP_ENTITY_ID WIP_ENTITY_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, DEPARTMENT_ID DEPARTMENT_ID, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, DATE_REQUIRED DATE_REQUIRED, REQUIRED_QTY REQUIRED_QTY, QUANTITY_ISSUED QUANTITY_ISSUED, QUANTITY_OPEN QUANTITY_OPEN, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, SUPPLY_SUBINVENOTRY SUPPLY_SUBINVENOTRY, SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID, ONHAND_QTY ONHAND_QTY, PROJ_AVAIL_QTY PROJ_AVAIL_QTY, SHORTAGE_QTY SHORTAGE_QTY, 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_COMP_SHORTAGE"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, DEPARTMENT_ID DEPARTMENT_ID
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, DATE_REQUIRED DATE_REQUIRED
, REQUIRED_QTY REQUIRED_QTY
, QUANTITY_ISSUED QUANTITY_ISSUED
, QUANTITY_OPEN QUANTITY_OPEN
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, SUPPLY_SUBINVENOTRY SUPPLY_SUBINVENOTRY
, SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID
, ONHAND_QTY ONHAND_QTY
, PROJ_AVAIL_QTY PROJ_AVAIL_QTY
, SHORTAGE_QTY SHORTAGE_QTY
, 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_COMP_SHORTAGE"