View: GML_BATCH_SO_RESERVATIONS_V1

Product:	GML - Process Manufacturing Logistics
Description:	OM Batch reservation view
Implementation/DBA Data:	APPS.GML_BATCH_SO_RESERVATIONS_V1

View Text

SELECT OH.ORDER_NUMBER
, OH.ORDER_TYPE_ID
, OH.HEADER_ID
, OL.LINE_NUMBER
, OL.LINE_ID
, OTTT.DESCRIPTION
, BH.BATCH_NO
, BH.BATCH_ID
, BH.PLANT_CODE
, DECODE(BH.BATCH_TYPE
, 0
, 'BATCH'
, 10
, 'FPO')
, BH.BATCH_TYPE
, ITM.ITEM_NO
, RES.WHSE_CODE
, RES.BATCH_RES_ID
, RES.ORGANIZATION_ID
, DECODE(BH.BATCH_STATUS
, 1
, 'PENDING'
, 2
, 'WIP'
, 3
, 'COMPLETED'
, BH.BATCH_STATUS)
, BATCH_STATUS
, RA.CUSTOMER_NAME
, RA.CUSTOMER_ID
, OL.SCHEDULE_SHIP_DATE
, OL.ORDERED_QUANTITY
, OL.ORDERED_QUANTITY2
, OL.ORDER_QUANTITY_UOM
, OL.ORDERED_QUANTITY_UOM2
, DECODE(BH.ACTUAL_START_DATE
, NULL
, BH.PLAN_START_DATE
, BH.ACTUAL_START_DATE)
, RES.QTY_UOM
, RES.QTY2_UOM
, RES.ITEM_ID
, ITM.DUALUM_IND
, ITM.LOT_CTL
, ITM.STATUS_CTL
, ITM.GRADE_CTL
, ITM.LOCT_CTL
, ITM.SUBLOT_CTL
, ITM.NONINV_IND
, ITM.LOT_INDIVISIBLE
, ITM.ITEM_UM
, ITM.ITEM_UM2
, RES.BATCH_LINE_ID
, DECODE(BH.ACTUAL_CMPLT_DATE
, NULL
, BH.PLAN_CMPLT_DATE
, BH.ACTUAL_CMPLT_DATE)
, RES.RESERVED_QTY
, RES.RESERVED_QTY2
FROM OE_ORDER_HEADERS_ALL OH
, OE_ORDER_LINES_ALL OL
, RA_CUSTOMERS RA
, GML_BATCH_SO_RESERVATIONS RES
, GME_BATCH_HEADER BH
, GME_MATERIAL_DETAILS BL
, OE_TRANSACTION_TYPES_TL OTTT
, IC_ITEM_MST_B ITM
WHERE BH.BATCH_ID = BL.BATCH_ID
AND BH.BATCH_STATUS >=1
AND BH.BATCH_STATUS < 4
AND RES.BATCH_ID = BH.BATCH_ID
AND RES.BATCH_LINE_ID = BL.MATERIAL_DETAIL_ID
AND RES.ORDER_ID = OH.HEADER_ID
AND RES.DELETE_MARK = 0
AND RES.SO_LINE_ID = OL.LINE_ID
AND OH.HEADER_ID = OL.HEADER_ID
AND OH.ORDER_TYPE_ID = OTTT.TRANSACTION_TYPE_ID
AND ITM.ITEM_ID = RES.ITEM_ID
AND OL.SOLD_TO_ORG_ID = RA.CUSTOMER_ID
AND OTTT.LANGUAGE = USERENV( 'LANG')

Columns