eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: GML_SO_RESERVATIONS_V

Product:	GML - Process Manufacturing Logistics
Description:	View for Batch Reservations
Implementation/DBA Data:	APPS.GML_SO_RESERVATIONS_V

View Text

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

Columns

Name
BATCH_RES_ID
BATCH_ID
BATCH_NO
BATCH_LINE_ID
WHSE_CODE
DELIVERY_DETAIL_ID
BATCH_TYPE
BATCH_STATUS
START_DATE
PLAN_CMPLT_DATE
RESERVED_QUANTITY
RESERVED_QUANTITY2
PLANNED_QUANTITY
PLANNED_QUANTITY2
COMMIT_QUANTITY
COMMIT_QUANTITY2