eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AP_PURGE_PVT dependencies on PO_LINES

Line 1816: FROM po_lines PL

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
1816: FROM po_lines PL
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

Line 1877: FROM po_lines PL

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
1877: FROM po_lines PL
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

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 3382: FROM po_lines PL

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
3382: FROM po_lines PL
3383: WHERE PL.po_header_id = PPL.po_header_id
3384: AND (PL.last_update_date > p_last_activity_date
3385: OR
3386: EXISTS

Line 3451: FROM po_lines PL

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
3451: FROM po_lines PL
3452: WHERE PL.po_header_id = PH.po_header_id
3453: AND (PL.last_update_date > p_last_activity_date
3454: OR
3455: EXISTS

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 4798: --SQL What: Delete po lines with header within the range

4794: END IF;
4795:
4796: l_progress := '040';
4797:
4798: --SQL What: Delete po lines with header within the range
4799: DELETE
4800: FROM po_lines PL
4801: WHERE EXISTS (
4802: SELECT NULL

Line 4800: FROM po_lines PL

4796: l_progress := '040';
4797:
4798: --SQL What: Delete po lines with header within the range
4799: DELETE
4800: FROM po_lines PL
4801: WHERE EXISTS (
4802: SELECT NULL
4803: FROM po_purge_po_list PPL
4804: WHERE PPL.po_header_id = PL.po_header_id

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 4873: --SQL What: Delete po lines archive with header within the range

4869: --
4870:
4871: l_progress := '050';
4872:
4873: --SQL What: Delete po lines archive with header within the range
4874: DELETE
4875: FROM po_lines_archive PLA
4876: WHERE EXISTS (
4877: SELECT NULL

Line 4875: FROM po_lines_archive PLA

4871: l_progress := '050';
4872:
4873: --SQL What: Delete po lines archive with header within the range
4874: DELETE
4875: FROM po_lines_archive PLA
4876: WHERE EXISTS (
4877: SELECT NULL
4878: FROM po_purge_po_list PPL
4879: WHERE PPL.po_header_id = PLA.po_header_id

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