APPS.PO_AP_PURGE_PVT dependencies on PO_RELEASES

Line 1811: FROM po_releases PR

1807: AND (PH.closed_code = 'FINALLY CLOSED'
1808: OR PH.cancel_flag = 'Y')
1809: AND NOT EXISTS
1810: (SELECT NULL
1811: FROM po_releases PR
1812: WHERE PR.po_header_id = PH.po_header_id
1813: AND PR.last_update_date > p_last_activity_date)
1814: AND NOT EXISTS
1815: (SELECT NULL

Line 1872: FROM po_releases PR

1868: AND (PH.closed_code = 'FINALLY CLOSED'
1869: OR PH.cancel_flag = 'Y')
1870: AND NOT EXISTS
1871: (SELECT NULL
1872: FROM po_releases PR
1873: WHERE PR.po_header_id = PH.po_header_id
1874: AND PR.last_update_date > p_last_activity_date)
1875: AND NOT EXISTS
1876: (SELECT NULL

Line 3377: FROM po_releases PR

3373: OR PH.closed_code = 'FINALLY CLOSED')
3374: AND PH.last_update_date <= p_last_activity_date
3375: AND NOT EXISTS
3376: (SELECT NULL
3377: FROM po_releases PR
3378: WHERE PR.po_header_id = PPL.po_header_id
3379: AND PR.last_update_date > p_last_activity_date)
3380: AND NOT EXISTS
3381: (SELECT NULL

Line 3446: FROM po_releases PR

3442: OR PH.closed_code = 'FINALLY CLOSED')
3443: AND PH.last_update_date <= p_last_activity_date
3444: AND NOT EXISTS
3445: (SELECT NULL
3446: FROM po_releases PR
3447: WHERE PR.po_header_id = PH.po_header_id
3448: AND PR.last_update_date > p_last_activity_date)
3449: AND NOT EXISTS
3450: (SELECT NULL

Line 4298: po_releases PREL,

4294: p_purge_name,
4295: PH.org_id -- bug5446437
4296: FROM po_vendor_sites VDS,
4297: per_all_people_f PAPF,
4298: po_releases PREL,
4299: po_headers PH,
4300: po_line_locations PLL,
4301: po_purge_po_list PPL
4302: WHERE PPL.po_header_id = PH.po_header_id

Line 5040: --SQL What: Delete po releases with header within the range

5036: END IF;
5037:
5038: l_progress := '100';
5039:
5040: --SQL What: Delete po releases with header within the range
5041: DELETE
5042: FROM po_releases PR
5043: WHERE EXISTS (
5044: SELECT NULL

Line 5042: FROM po_releases PR

5038: l_progress := '100';
5039:
5040: --SQL What: Delete po releases with header within the range
5041: DELETE
5042: FROM po_releases PR
5043: WHERE EXISTS (
5044: SELECT NULL
5045: FROM po_purge_po_list PPL
5046: WHERE PPL.po_header_id = PR.po_header_id

Line 5068: --SQL What: Delete po releases archive with header within the range

5064: END IF;
5065:
5066: l_progress := '110';
5067:
5068: --SQL What: Delete po releases archive with header within the range
5069: DELETE
5070: FROM po_releases_archive PRA
5071: WHERE EXISTS (
5072: SELECT NULL

Line 5070: FROM po_releases_archive PRA

5066: l_progress := '110';
5067:
5068: --SQL What: Delete po releases archive with header within the range
5069: DELETE
5070: FROM po_releases_archive PRA
5071: WHERE EXISTS (
5072: SELECT NULL
5073: FROM po_purge_po_list PPL
5074: WHERE PPL.po_header_id = PRA.po_header_id