Product: | GML - Process Manufacturing Logistics |
---|---|
Description: | View for Batch Reservations |
Implementation/DBA Data: | APPS.GML_SO_RESERVATIONS_V |
SELECT BATCH_RES_ID
, BATCH_ID
, BATCH_NO
, BATCH_LINE_ID
, WHSE_CODE
, DELIVERY_DETAIL_ID
, BATCH_TYPE
, BATCH_STATUS
, START_DATE
, PLAN_CMPLT_DATE
, SUM(LINE_RESERVED_QTY)
, SUM(LINE_RESERVED_QTY2)
, SUM(NVL(PLANNED_QTY
, 0))
, SUM(NVL(PLANNED_QTY2
, 0))
, SUM(NVL(RESERVED_QTY
, 0)) + SUM(NVL(LINE_RESERVED_QTY
, 0))
, SUM(NVL(RESERVED_QTY2
, 0)) + SUM(NVL(LINE_RESERVED_QTY2
, 0))
FROM GML_BATCH_TMP GROUP BY BATCH_RES_ID
, BATCH_ID
, BATCH_NO
, BATCH_LINE_ID
, WHSE_CODE
, DELIVERY_DETAIL_ID
, BATCH_TYPE
, BATCH_STATUS
, START_DATE
, PLAN_CMPLT_DATE HAVING SUM(LINE_RESERVED_QTY) > 0 OR SUM(PLANNED_QTY) > 0