APPS.PO_AP_PURGE_PVT dependencies on PO_REQ_DISTRIBUTIONS

Line 1661: FROM po_req_distributions PRD

1657: p_last_activity_date)
1658: OR
1659: EXISTS (
1660: SELECT NULL
1661: FROM po_req_distributions PRD
1662: WHERE PRD.requisition_line_id =
1663: PRL.requisition_line_id
1664: AND PRD.last_update_date >
1665: p_last_activity_date)));

Line 1946: FROM po_req_distributions PRD

1942: PRL.source_type_code = 'INVENTORY'
1943: OR
1944: EXISTS (
1945: SELECT NULL
1946: FROM po_req_distributions PRD
1947: WHERE PRD.requisition_line_id =
1948: PRL.requisition_line_id
1949: AND PRD.last_update_date >
1950: p_last_activity_date)));

Line 2365: FROM po_req_distributions RD,

2361: SET PPRL.double_check_flag = 'N'
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 =

Line 2399: FROM po_req_distributions RD,

2395: SET PPRL.double_check_flag = 'N'
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 =

Line 3254: FROM po_req_distributions RD

3250: p_last_activity_date)
3251: OR
3252: EXISTS (
3253: SELECT NULL
3254: FROM po_req_distributions RD
3255: WHERE RD.requisition_line_id =
3256: RL.requisition_line_id
3257: AND RD.last_update_date >
3258: p_last_activity_date))));

Line 3539: FROM po_req_distributions RD

3535: p_last_activity_date)
3536: OR
3537: EXISTS (
3538: SELECT NULL
3539: FROM po_req_distributions RD
3540: WHERE RD.requisition_line_id =
3541: RL.requisition_line_id
3542: AND RD.last_update_date >
3543: p_last_activity_date))));

Line 4515: FROM po_req_distributions RD

4511: l_progress := '030';
4512:
4513: --SQL What: Delete req distributions with header within the range
4514: DELETE
4515: FROM po_req_distributions RD
4516: WHERE EXISTS (
4517: SELECT NULL
4518: FROM po_purge_req_list PPRL,
4519: po_requisition_lines RL