[Home] [Help]
1817: WHERE PL.po_header_id = PH.po_header_id
1818: AND PL.last_update_date > p_last_activity_date)
1819: AND NOT EXISTS
1820: (SELECT NULL
1821: FROM po_line_locations PLL
1822: WHERE PLL.po_header_id = PH.po_header_id
1823: AND PLL.last_update_date > p_last_activity_date)
1824: AND NOT EXISTS
1825: (SELECT NULL
1878: WHERE PL.po_header_id = PH.po_header_id
1879: AND PL.last_update_date > p_last_activity_date)
1880: AND NOT EXISTS
1881: (SELECT NULL
1882: FROM po_line_locations PLL
1883: WHERE PLL.po_header_id = PH.po_header_id
1884: AND PLL.last_update_date > p_last_activity_date)
1885: AND NOT EXISTS
1886: (SELECT NULL
2798: SET PPL.double_check_flag = 'N'
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 (
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
2884: AND NOT EXISTS (
3392: AND PPD.last_update_date >
3393: p_last_activity_date)))
3394: AND NOT EXISTS
3395: (SELECT NULL
3396: FROM po_line_locations PLL
3397: WHERE PLL.po_header_id = PPL.po_header_id
3398: AND (PLL.last_update_date >p_last_activity_date
3399: OR
3400: EXISTS
3461: AND PPD.last_update_date >
3462: p_last_activity_date)))
3463: AND NOT EXISTS
3464: (SELECT NULL
3465: FROM po_line_locations PLL
3466: WHERE PLL.po_header_id = PH.po_header_id
3467: AND (PLL.last_update_date > p_last_activity_date
3468: OR
3469: EXISTS
4070: PH.org_id -- bug5446437
4071: FROM per_all_people_f PAPF,
4072: po_vendor_sites VDS,
4073: po_headers PH,
4074: po_line_locations PLL,
4075: po_purge_po_list PPL
4076: WHERE PPL.po_header_id BETWEEN l_range_low AND l_range_high
4077: AND PPL.double_check_flag = 'Y'
4078: AND PPL.po_header_id = PH.po_header_id
4146: PH.org_id -- bug5446437
4147: FROM per_all_people_f PAPF,
4148: po_vendor_sites VDS,
4149: po_headers PH,
4150: po_line_locations_all PLL,
4151: po_purge_po_list PPL
4152: WHERE PPL.po_header_id BETWEEN l_range_low AND l_range_high
4153: AND PPL.double_check_flag = 'Y'
4154: AND PPL.po_header_id = PH.po_header_id
4220: FROM per_all_people_f PAPF,
4221: po_vendor_sites VDS,
4222: po_headers PH,
4223: po_lines_all POL,
4224: po_line_locations_all PLL,
4225: po_purge_po_list PPL
4226: WHERE PPL.po_header_id BETWEEN l_range_low AND l_range_high
4227: AND PPL.double_check_flag = 'Y'
4228: AND PPL.po_header_id = PH.po_header_id
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
4303: AND PH.po_header_id = PREL.po_header_id
4304: AND PREL.po_release_id = PLL.po_release_id
4946: l_progress := '060';
4947:
4948: --SQL What: Delete po line_loc with header within the range
4949: DELETE
4950: FROM po_line_locations PLL
4951: WHERE EXISTS (
4952: SELECT NULL
4953: FROM po_purge_po_list PPL
4954: WHERE PPL.po_header_id = PLL.po_header_id
4969: l_progress := '070';
4970:
4971: --SQL What: Delete po line_loc archive with header within the range
4972: DELETE
4973: FROM po_line_locations_archive PLLA
4974: WHERE EXISTS (
4975: SELECT NULL
4976: FROM po_purge_po_list PPL
4977: WHERE PPL.po_header_id = PLLA.po_header_id