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_HEADERS

Line 1429: -- Number of records in po_headers

1425: -- status of the procedure
1426: --x_msg_data
1427: -- This parameter will be not null if an error happens
1428: --x_po_hdr_coun
1429: -- Number of records in po_headers
1430: --x_rcv_line_count
1431: -- Number of records in rcv_shipment_lines
1432: --x_req_hdr_count
1433: -- Number of records in po_requisition_headers

Line 1505: FROM po_headers;

1501: x_return_status := FND_API.G_RET_STS_SUCCESS;
1502:
1503: SELECT COUNT(1)
1504: INTO x_po_hdr_count
1505: FROM po_headers;
1506:
1507: l_progress := '010';
1508:
1509: SELECT COUNT(1)

Line 1803: FROM po_headers PH

1799: )
1800: SELECT PH.po_header_id,
1801: p_purge_name,
1802: 'Y'
1803: FROM po_headers PH
1804: WHERE PH.type_lookup_code IN ('STANDARD', 'PLANNED',
1805: 'BLANKET', 'CONTRACT')
1806: AND PH.last_update_date <= p_last_activity_date
1807: AND (PH.closed_code = 'FINALLY CLOSED'

Line 1864: FROM po_headers PH

1860: )
1861: SELECT PH.po_header_id,
1862: p_purge_name,
1863: 'Y'
1864: FROM po_headers PH
1865: WHERE PH.type_lookup_code IN ('STANDARD', 'PLANNED',
1866: 'BLANKET', 'CONTRACT')
1867: AND PH.last_update_date <= p_last_activity_date
1868: AND (PH.closed_code = 'FINALLY CLOSED'

Line 2828: po_headers_all POH

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'
2832: AND POH.global_agreement_flag = 'Y'

Line 2853: FROM po_headers_all POH,

2849: PPL1.po_header_id))
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'

Line 3368: FROM po_headers PH

3364: SET double_check_flag = 'N'
3365: WHERE double_check_flag = 'Y'
3366: AND NOT EXISTS (
3367: SELECT NULL
3368: FROM po_headers PH
3369: WHERE PH.po_header_id = PPL.po_header_id
3370: AND PH.type_lookup_code IN ('STANDARD', 'BLANKET',
3371: 'PLANNED', 'CONTRACT')
3372: AND (PH.cancel_flag = 'Y'

Line 3437: FROM po_headers PH

3433: SET double_check_flag = 'N'
3434: WHERE double_check_flag = 'Y'
3435: AND NOT EXISTS (
3436: SELECT NULL
3437: FROM po_headers PH
3438: WHERE PH.po_header_id = PPL.po_header_id
3439: AND PH.type_lookup_code IN ('STANDARD', 'BLANKET',
3440: 'PLANNED', 'CONTRACT')
3441: AND (PH.cancel_flag = 'Y'

Line 4005: FROM po_headers PH,

4001: INTO l_range_inserted
4002: FROM dual
4003: WHERE EXISTS (
4004: SELECT NULL
4005: FROM po_headers PH,
4006: po_history_pos PHP
4007: WHERE PH.segment1 = PHP.segment1
4008: AND PH.type_lookup_code = PHP.type_lookup_code
4009: AND PHP.purge_name = p_purge_name

Line 4073: po_headers PH,

4069: p_purge_name,
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'

Line 4149: po_headers PH,

4145: p_purge_name,
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'

Line 4222: po_headers PH,

4218: p_purge_name,
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

Line 4299: po_headers PH,

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
4303: AND PH.po_header_id = PREL.po_header_id

Line 4748: --SQL What: Delete po headers within the range

4744: END IF;
4745:
4746: l_progress := '020';
4747:
4748: --SQL What: Delete po headers within the range
4749: DELETE
4750: FROM po_headers PH
4751: WHERE EXISTS (
4752: SELECT NULL

Line 4750: FROM po_headers PH

4746: l_progress := '020';
4747:
4748: --SQL What: Delete po headers within the range
4749: DELETE
4750: FROM po_headers PH
4751: WHERE EXISTS (
4752: SELECT NULL
4753: FROM po_purge_po_list PPL
4754: WHERE PPL.po_header_id = PH.po_header_id

Line 4775: --SQL What: Delete po headers archive within the range

4771: END IF;
4772:
4773: l_progress := '030';
4774:
4775: --SQL What: Delete po headers archive within the range
4776: DELETE
4777: FROM po_headers_archive PHA
4778: WHERE EXISTS (
4779: SELECT NULL

Line 4777: FROM po_headers_archive PHA

4773: l_progress := '030';
4774:
4775: --SQL What: Delete po headers archive within the range
4776: DELETE
4777: FROM po_headers_archive PHA
4778: WHERE EXISTS (
4779: SELECT NULL
4780: FROM po_purge_po_list PPL
4781: WHERE PPL.po_header_id = PHA.po_header_id