APPS.PO_AP_PURGE_PVT dependencies on PO_LINES_ALL

Line 2815: FROM po_lines_all POL

2811: AND PRL.double_check_flag = 'Y'))
2812: OR
2813: EXISTS ( -- rm po if contract not in purge list
2814: SELECT NULL
2815: FROM po_lines_all POL
2816: WHERE POL.po_header_id = PPL.po_header_id
2817: AND POL.contract_id IS NOT NULL
2818: AND NOT EXISTS (
2819: SELECT NULL

Line 2827: FROM po_lines_all POL,

2823: POL.contract_id))
2824: OR
2825: EXISTS ( -- rm po if ga not in purge list
2826: SELECT NULL
2827: FROM po_lines_all POL,
2828: po_headers_all POH
2829: WHERE PPL.po_header_id = POL.po_header_id
2830: AND POL.from_header_id = POH.po_header_id
2831: AND POH.type_lookup_code = 'BLANKET'

Line 2842: FROM po_lines_all POL

2838: PPL1.po_Header_id))
2839: OR
2840: EXISTS ( -- rm contract if po not in purge list
2841: SELECT NULL
2842: FROM po_lines_all POL
2843: WHERE PPL.po_header_id = POL.contract_id
2844: AND NOT EXISTS (
2845: SELECT NULL
2846: FROM po_purge_po_list PPL1

Line 2854: po_lines_all POL

2850: OR
2851: EXISTS ( -- rm ga if po not in purge list
2852: SELECT NULL
2853: FROM po_headers_all POH,
2854: po_lines_all POL
2855: WHERE POH.po_header_id = PPL.po_header_id
2856: AND POH.type_lookup_code = 'BLANKET'
2857: AND POH.global_agreement_flag = 'Y'
2858: AND POL.from_header_id = POH.po_header_id

Line 4223: po_lines_all POL,

4219: PH.org_id -- bug5446437
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'

Line 4828: po_lines_all POL

4824: FROM PO_ATTRIBUTE_VALUES POATR
4825: WHERE EXISTS (
4826: SELECT NULL
4827: FROM po_purge_po_list PPL,
4828: po_lines_all POL
4829: WHERE PPL.po_header_id = POL.po_header_id
4830: AND POATR.po_line_id = POL.po_line_id
4831: AND PPL.double_check_flag = 'Y'
4832: AND PPL.po_header_id BETWEEN l_range_low

Line 4853: po_lines_all POL

4849: FROM PO_ATTRIBUTE_VALUES_TLP POTLP
4850: WHERE EXISTS (
4851: SELECT NULL
4852: FROM po_purge_po_list PPL,
4853: po_lines_all POL
4854: WHERE PPL.po_header_id = POL.po_header_id
4855: AND POTLP.po_line_id = POL.po_line_id
4856: AND PPL.double_check_flag = 'Y'
4857: AND PPL.po_header_id BETWEEN l_range_low

Line 4903: po_lines_all POL

4899: FROM PO_ATTR_VALUES_ARCHIVE POATRA
4900: WHERE EXISTS (
4901: SELECT NULL
4902: FROM po_purge_po_list PPL,
4903: po_lines_all POL
4904: WHERE PPL.po_header_id = POL.po_header_id
4905: AND POATRA.po_line_id = POL.po_line_id
4906: AND PPL.double_check_flag = 'Y'
4907: AND PPL.po_header_id BETWEEN l_range_low

Line 4928: po_lines_all POL

4924: FROM PO_ATTR_VALUES_TLP_ARCHIVE POTLPA
4925: WHERE EXISTS (
4926: SELECT NULL
4927: FROM po_purge_po_list PPL,
4928: po_lines_all POL
4929: WHERE PPL.po_header_id = POL.po_header_id
4930: AND POTLPA.po_line_id = POL.po_line_id
4931: AND PPL.double_check_flag = 'Y'
4932: AND PPL.po_header_id BETWEEN l_range_low