[Home] [Help]
1638: AND (PRH.closed_code = 'FINALLY CLOSED'
1639: OR PRH.authorization_status = 'CANCELLED')
1640: AND NOT EXISTS
1641: (SELECT NULL
1642: FROM po_requisition_lines PRL
1643: WHERE PRL.requisition_header_id = PRH.requisition_header_id
1644: AND NVL(PRL.modified_by_agent_flag, 'N') = 'N'
1645: AND (PRL.last_update_date > p_last_activity_date
1646: OR
1932: AND (PRH.closed_code = 'FINALLY CLOSED'
1933: OR PRH.authorization_status = 'CANCELLED')
1934: AND NOT EXISTS
1935: (SELECT NULL
1936: FROM po_requisition_lines PRL
1937: WHERE PRL.requisition_header_id =
1938: PRH.requisition_header_id
1939: AND NVL(PRL.modified_by_agent_flag, 'N') = 'N'
1940: AND (PRL.last_update_date > p_last_activity_date
2362: WHERE PPRL.double_check_flag = 'Y'
2363: AND EXISTS
2364: (SELECT NULL
2365: FROM po_req_distributions RD,
2366: po_requisition_lines RL
2367: WHERE RL.requisition_header_id =
2368: PPRL.requisition_header_id
2369: AND RD.requisition_line_id =
2370: RL.requisition_line_id
2396: WHERE PPRL.double_check_flag = 'Y'
2397: AND EXISTS
2398: (SELECT NULL
2399: FROM po_req_distributions RD,
2400: po_requisition_lines RL
2401: WHERE RL.requisition_header_id =
2402: PPRL.requisition_header_id
2403: AND RD.requisition_line_id =
2404: RL.requisition_line_id
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
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
3229: AND (RH.closed_code = 'FINALLY CLOSED'
3230: OR RH.authorization_status = 'CANCELLED')
3231: AND NOT EXISTS (
3232: SELECT NULL
3233: FROM po_requisition_lines RL
3234: WHERE RL.requisition_header_id =
3235: RH.requisition_header_id
3236: AND NVL(RL.modified_by_agent_flag,'N') = 'N'
3237: AND (RL.last_update_date > p_last_activity_date
3516: AND (RH.closed_code = 'FINALLY CLOSED'
3517: OR RH.authorization_status = 'CANCELLED')
3518: AND NOT EXISTS (
3519: SELECT NULL
3520: FROM po_requisition_lines RL
3521: WHERE RL.requisition_header_id =
3522: RH.requisition_header_id
3523: AND NVL(RL.modified_by_agent_flag,'N') = 'N'
3524: AND (RL.last_update_date > p_last_activity_date
3853: RH.org_id -- bug5446437
3854: FROM po_purge_req_list PRL,
3855: per_all_people_f PAPF,
3856: po_requisition_headers RH,
3857: po_requisition_lines RL
3858: WHERE PRL.requisition_header_id = RH.requisition_header_id
3859: AND RH.requisition_header_id = RL.requisition_header_id
3860: AND RH.preparer_id = PAPF.person_id
3861: AND TRUNC(SYSDATE) BETWEEN PAPF.effective_start_date
4515: FROM po_req_distributions RD
4516: WHERE EXISTS (
4517: SELECT NULL
4518: FROM po_purge_req_list PPRL,
4519: po_requisition_lines RL
4520: WHERE PPRL.requisition_header_id =
4521: RL.requisition_header_id
4522: AND RL.requisition_line_id =
4523: RD.requisition_line_id
4538: l_progress := '040';
4539:
4540: --SQL What: Delete req lines with header within the range
4541: DELETE
4542: FROM po_requisition_lines RL
4543: WHERE EXISTS (
4544: SELECT NULL
4545: FROM po_purge_req_list PPRL
4546: WHERE PPRL.requisition_header_id =
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,