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