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

Line 122: rcv_shipment_headers RSH,

118: RSL.item_description,
119: p_purge_name
120: FROM per_all_people_f PAPF,
121: rcv_shipment_lines RSL,
122: rcv_shipment_headers RSH,
123: po_purge_po_list PPL
124: WHERE PPL.double_check_flag = 'Y'
125: AND PPL.po_header_id = RSL.po_header_id
126: AND PPL.po_header_id BETWEEN l_range_low AND l_range_high

Line 264: --SQL What: Delete records from rcv_shipment_headers if all the

260: AND l_range_high);
261:
262: l_progress := '030';
263:
264: --SQL What: Delete records from rcv_shipment_headers if all the
265: -- shipment lines for these headers have been deleted, and
266: -- there is not pending transaction for these headers. The
267: -- returning clause will collect all shipment headers that
268: -- have been deleted so that we can notify the same to MRC

Line 271: FROM rcv_shipment_headers RSH

267: -- returning clause will collect all shipment headers that
268: -- have been deleted so that we can notify the same to MRC
269: -- in an MRC call out later in this procedure
270: DELETE
271: FROM rcv_shipment_headers RSH
272: WHERE NOT EXISTS (
273: SELECT NULL
274: FROM rcv_shipment_lines RSL
275: WHERE RSL.shipment_header_id =