DBA Data[Home] [Help]

APPS.PO_AP_PURGE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 2802: FROM po_line_locations_all PLL,

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 (

Line 2880: po_line_locations_all PLL

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 (

Line 4150: po_line_locations_all PLL,

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

Line 4224: po_line_locations_all PLL,

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