APPS.PO_AP_PURGE_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 2803: po_requisition_lines_all RL

2799: WHERE PPL.double_check_flag = 'Y'
2800: AND (EXISTS ( -- rm po if req not in purge list
2801: SELECT NULL
2802: FROM po_line_locations_all PLL,
2803: po_requisition_lines_all RL
2804: WHERE PLL.po_header_id = PPL.po_header_id
2805: AND PLL.line_location_id = RL.line_location_id
2806: AND NOT EXISTS (
2807: SELECT NULL

Line 2879: FROM po_requisition_lines_all RL,

2875: SET PPRL.double_check_flag = 'N'
2876: WHERE PPRL.double_check_flag = 'Y'
2877: AND EXISTS (
2878: SELECT NULL
2879: FROM po_requisition_lines_all RL,
2880: po_line_locations_all PLL
2881: WHERE RL.requisition_header_id =
2882: PPRL.requisition_header_id
2883: AND RL.line_location_id = PLL.line_location_id

Line 5140: UPDATE po_requisition_lines_all PRL

5136: l_progress := '140';
5137:
5138: --SQL What: NULL out src doc reference for reqs if the src doc has been
5139: -- purged
5140: UPDATE po_requisition_lines_all PRL
5141: SET PRL.blanket_po_header_id = NULL,
5142: PRL.blanket_po_line_num = NULL,
5143: PRL.last_update_date = SYSDATE,
5144: PRL.last_updated_by = FND_GLOBAL.user_id,