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.CSD_INTERNAL_ORDERS_PVT dependencies on RCV_SHIPMENT_HEADERS

Line 82: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl

78:
79: -- 2 .get the shipment header id and line id.
80: SELECT rsh.shipment_header_id, rsl.shipment_line_id,rsh.shipment_num,rsh.shipped_date,rsl.quantity_shipped
81: BULK COLLECT INTO l_shipment_header_id,l_shipment_line_id,l_shipment_num,l_shipped_date,l_quantity
82: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl
83: WHERE rsl.requisition_line_id = l_requisition_line_id
84: AND rsh.shipment_header_id = rsl.shipment_header_id
85: AND nvl(rsl.quantity_received,0) = 0
86: AND rsl.mmt_transaction_id IN (SELECT mmt.transaction_id

Line 1828: rcv_shipment_headers rsh,

1824: SELECT SUM(rt.quantity)
1825: INTO l_received_quantity
1826: FROM csd_product_transactions cpt,
1827: po_requisition_lines_all prl,
1828: rcv_shipment_headers rsh,
1829: rcv_shipment_lines rsl,
1830: rcv_transactions rt
1831: WHERE cpt.product_transaction_id = p_product_txn_id
1832: AND cpt.req_header_id = prl.requisition_header_id