APPS.GML_RCV_DB_COMMON dependencies on WSH_DELIVERY_DETAILS

Line 627: FROM wsh_delivery_details wdd, wsh_delivery_assignments assign,ic_tran_pnd ic,

623: /* Selecting the shipped quantity for that Lot and Sublot */
624:
625: Cursor Cr_Io_lot_shipped_qty IS
626: SELECT ic.trans_um ,sum(ic.trans_qty)*-1
627: FROM wsh_delivery_details wdd, wsh_delivery_assignments assign,ic_tran_pnd ic,
628: oe_order_lines_all ol
629: WHERE ic.lot_id = p_lot_id
630: and assign.delivery_id = p_order_num
631: and wdd.delivery_detail_id =assign.delivery_detail_id