VIEW: GML.GML_BATCH_SO_RESERVATIONS#

Source

View Text - Preformatted

select BATCH_RES_ID BATCH_RES_ID, BATCH_ID BATCH_ID, ORDER_ID ORDER_ID, BATCH_LINE_ID BATCH_LINE_ID, SO_LINE_ID SO_LINE_ID, DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID, MO_LINE_ID MO_LINE_ID, ITEM_ID ITEM_ID, RESERVED_QTY RESERVED_QTY, RESERVED_QTY2 RESERVED_QTY2, QTY_UOM QTY_UOM, QTY2_UOM QTY2_UOM, WHSE_CODE WHSE_CODE, BATCH_TYPE BATCH_TYPE, DELETE_MARK DELETE_MARK, ALLOCATED_IND ALLOCATED_IND, ORGANIZATION_ID ORGANIZATION_ID, RULE_ID RULE_ID, FULFILLED_QTY FULFILLED_QTY, FULFILLED_QTY2 FULFILLED_QTY2, FULFILLMENT_DATE FULFILLMENT_DATE, SCHEDULED_SHIP_DATE SCHEDULED_SHIP_DATE, SHIPMENT_PRIORITY SHIPMENT_PRIORITY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID from "GML"."GML_BATCH_SO_RESERVATIONS"

View Text - HTML Formatted

SELECT BATCH_RES_ID BATCH_RES_ID
, BATCH_ID BATCH_ID
, ORDER_ID ORDER_ID
, BATCH_LINE_ID BATCH_LINE_ID
, SO_LINE_ID SO_LINE_ID
, DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, MO_LINE_ID MO_LINE_ID
, ITEM_ID ITEM_ID
, RESERVED_QTY RESERVED_QTY
, RESERVED_QTY2 RESERVED_QTY2
, QTY_UOM QTY_UOM
, QTY2_UOM QTY2_UOM
, WHSE_CODE WHSE_CODE
, BATCH_TYPE BATCH_TYPE
, DELETE_MARK DELETE_MARK
, ALLOCATED_IND ALLOCATED_IND
, ORGANIZATION_ID ORGANIZATION_ID
, RULE_ID RULE_ID
, FULFILLED_QTY FULFILLED_QTY
, FULFILLED_QTY2 FULFILLED_QTY2
, FULFILLMENT_DATE FULFILLMENT_DATE
, SCHEDULED_SHIP_DATE SCHEDULED_SHIP_DATE
, SHIPMENT_PRIORITY SHIPMENT_PRIORITY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
FROM "GML"."GML_BATCH_SO_RESERVATIONS"