APPS.RCV_AP_PURGE_PVT dependencies on RCV_SHIPMENT_LINES

Line 121: rcv_shipment_lines RSL,

117: PAPF.full_name,
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

Line 250: --SQL What: Delete records from rcv_shipment_lines if the pos

246: IF (g_fnd_debug = 'Y') THEN
247: asn_debug.put_line('Begin deleting rcv. low = ' || l_range_low ||' high = ' || l_range_high);
248: END IF;
249:
250: --SQL What: Delete records from rcv_shipment_lines if the pos
251: -- they associate with are in the purge list
252: DELETE
253: FROM rcv_shipment_lines RSL
254: WHERE EXISTS (

Line 253: FROM rcv_shipment_lines RSL

249:
250: --SQL What: Delete records from rcv_shipment_lines if the pos
251: -- they associate with are in the purge list
252: DELETE
253: FROM rcv_shipment_lines RSL
254: WHERE EXISTS (
255: SELECT NULL
256: FROM po_purge_po_list PPL
257: WHERE PPL.po_header_id = RSL.po_header_id

Line 274: FROM rcv_shipment_lines RSL

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 =
276: RSH.shipment_header_id)
277: AND NOT EXISTS (
278: SELECT NULL

Line 330: FROM rcv_shipment_lines RSL

326: WHERE (RLS.shipment_line_id > 0
327: AND
328: NOT EXISTS (
329: SELECT NULL
330: FROM rcv_shipment_lines RSL
331: WHERE RSL.shipment_line_id = RLS.shipment_line_id))
332: OR (RLS.transaction_id > 0
333: AND
334: NOT EXISTS (

Line 348: FROM rcv_shipment_lines RSL

344: WHERE (RSS.shipment_line_id > 0
345: AND
346: NOT EXISTS (
347: SELECT NULL
348: FROM rcv_shipment_lines RSL
349: WHERE RSL.shipment_line_id = RSS.shipment_line_id))
350: OR (RSS.transaction_id > 0
351: AND
352: NOT EXISTS (

Line 366: FROM rcv_shipment_lines RSL

362: WHERE (RLT.shipment_line_id > 0
363: AND
364: NOT EXISTS (
365: SELECT NULL
366: FROM rcv_shipment_lines RSL
367: WHERE RSL.shipment_line_id = RLT.shipment_line_id))
368: OR
369: (RLT.transaction_id > 0
370: AND

Line 385: FROM rcv_shipment_lines RSL

381: WHERE (RST.shipment_line_id > 0
382: AND
383: NOT EXISTS (
384: SELECT NULL
385: FROM rcv_shipment_lines RSL
386: WHERE RSL.shipment_line_id = RST.shipment_line_id))
387: OR
388: (RST.transaction_id > 0
389: AND