DBA Data[Home] [Help]

APPS.GML_RCV_DB_COMMON dependencies on RCV_TRANSACTIONS

Line 133: rcv_transactions rcv

129:
130: Cursor Cr_lot_recv_qty IS
131: Select Sum(trans_qty),trans_um
132: From ic_tran_pnd itp,
133: rcv_transactions rcv
134: Where rcv.oe_order_header_id = p_oe_header_id
135: And (rcv.oe_order_line_id = p_oe_line_id
136: or
137: rcv.oe_order_line_id in

Line 648: FROM ic_tran_pnd ic ,rcv_transactions rcv

644: /* Selecting the quantity received for that Lot and Sublot*/
645:
646: Cursor Cr_Io_delivered_quantity IS
647: SELECT ic.trans_um,sum(ic.trans_qty)
648: FROM ic_tran_pnd ic ,rcv_transactions rcv
649: WHERE ic.lot_id = p_lot_id and ic.doc_type ='PORC'
650: and ic.line_id =rcv.transaction_id
651: and rcv.requisition_line_id = p_req_line_id
652: and rcv.shipment_header_id = p_shipment_header_id