VIEW: APPS.GML_SO_RESERVATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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