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 326: FROM rcv_shipment_lines RSL

322: WHERE (RLS.shipment_line_id > 0
323: AND
324: NOT EXISTS (
325: SELECT NULL
326: FROM rcv_shipment_lines RSL
327: WHERE RSL.shipment_line_id = RLS.shipment_line_id))
328: OR (RLS.transaction_id > 0
329: AND
330: NOT EXISTS (

Line 344: FROM rcv_shipment_lines RSL

340: WHERE (RSS.shipment_line_id > 0
341: AND
342: NOT EXISTS (
343: SELECT NULL
344: FROM rcv_shipment_lines RSL
345: WHERE RSL.shipment_line_id = RSS.shipment_line_id))
346: OR (RSS.transaction_id > 0
347: AND
348: NOT EXISTS (

Line 362: FROM rcv_shipment_lines RSL

358: WHERE (RLT.shipment_line_id > 0
359: AND
360: NOT EXISTS (
361: SELECT NULL
362: FROM rcv_shipment_lines RSL
363: WHERE RSL.shipment_line_id = RLT.shipment_line_id))
364: OR
365: (RLT.transaction_id > 0
366: AND

Line 381: FROM rcv_shipment_lines RSL

377: WHERE (RST.shipment_line_id > 0
378: AND
379: NOT EXISTS (
380: SELECT NULL
381: FROM rcv_shipment_lines RSL
382: WHERE RSL.shipment_line_id = RST.shipment_line_id))
383: OR
384: (RST.transaction_id > 0
385: AND