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.CHV_INQ_SV dependencies on RCV_TRANSACTIONS

Line 37: from rcv_transactions rct,

33: into x_transaction_date,
34: x_shipment_number,
35: x_quantity_received,
36: x_receiving_unit_of_measure
37: from rcv_transactions rct,
38: rcv_shipment_headers rsh,
39: rcv_shipment_lines rsl
40: where transaction_id = p_last_receipt_transaction_id
41: and rct.shipment_header_id = rsh.shipment_header_id

Line 55: from rcv_transactions rct where

51: select sum(quantity_received)
52: into x_quantity_received
53: from rcv_shipment_lines rsl
54: where rsl.shipment_header_id=(select rct.shipment_header_id
55: from rcv_transactions rct where
56: transaction_id = p_last_receipt_transaction_id)
57: and rsl.item_id = p_item_id;
58:
59: --End of Bug 1706360

Line 662: from rcv_transactions rct,

658: begin
659:
660: select max(rct.transaction_id)
661: into x_last_receipt_id
662: from rcv_transactions rct,
663: rcv_shipment_lines rsl,
664: po_headers poh
665: where rct.shipment_line_id = rsl.shipment_line_id
666: and rct.transaction_type = 'RECEIVE'

Line 678: from rcv_transactions rct2,

674: and poh.vendor_site_id = x_vendor_site_id
675: and poh.supply_agreement_flag = 'Y'
676: and rct.transaction_date in
677: (select max(rct2.transaction_date)
678: from rcv_transactions rct2,
679: rcv_shipment_lines rsl2,
680: po_headers poh2
681: where rct2.shipment_line_id = rsl2.shipment_line_id
682: and rct2.transaction_type = 'RECEIVE'