eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GML_RCV_DB_COMMON dependencies on IC_TRAN_PND

Line 132: From ic_tran_pnd itp,

128: l_rma_answer BOOLEAN := FALSE;
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

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

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