DBA Data[Home] [Help]

APPS.GML_BATCH_OM_RES_PVT dependencies on WSH_DELIVERY_DETAILS

Line 324: , wsh_delivery_details wdd

320: , res.so_line_id
321: , res.delivery_detail_id
322: , res.batch_id
323: From gml_batch_so_reservations res
324: , wsh_delivery_details wdd
325: Where res.batch_line_id = p_batch_line_id
326: and res.delete_mark = 0
327: and res.reserved_qty <> 0
328: and res.whse_code = p_whse_code

Line 1736: From wsh_delivery_details wdd

1732: ;
1733:
1734: Cursor get_mo_line_id (p_batch_line_id IN NUMBER ) IS
1735: Select distinct wdd.move_order_line_id
1736: From wsh_delivery_details wdd
1737: , ic_tran_pnd ictran
1738: Where wdd.delivery_detail_id = ictran.line_detail_id
1739: and ictran.delete_mark = 0
1740: and ictran.trans_id in