APPS.PO_AP_PURGE_PVT dependencies on PO_REQUISITION_HEADERS

Line 1433: -- Number of records in po_requisition_headers

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
1434: --x_vendor_count
1435: -- Number of records in po_vendors
1436: --x_asl_count
1437: -- Number of records in po_approved_supplier_list

Line 1517: FROM po_requisition_headers;

1513: l_progress := '020';
1514:
1515: SELECT COUNT(1)
1516: INTO x_req_hdr_count
1517: FROM po_requisition_headers;
1518:
1519: l_progress := '030';
1520:
1521: SELECT COUNT(1)

Line 1636: FROM po_requisition_headers PRH

1632: )
1633: SELECT PRH.requisition_header_id,
1634: p_purge_name,
1635: 'Y'
1636: FROM po_requisition_headers PRH
1637: WHERE PRH.last_update_date <= p_last_activity_date
1638: AND (PRH.closed_code = 'FINALLY CLOSED'
1639: OR PRH.authorization_status = 'CANCELLED')
1640: AND NOT EXISTS

Line 1930: FROM po_requisition_headers PRH

1926: )
1927: SELECT PRH.requisition_header_id,
1928: p_purge_name,
1929: 'Y'
1930: FROM po_requisition_headers PRH
1931: WHERE PRH.last_update_date <= p_last_activity_date
1932: AND (PRH.closed_code = 'FINALLY CLOSED'
1933: OR PRH.authorization_status = 'CANCELLED')
1934: AND NOT EXISTS

Line 3225: FROM po_requisition_headers RH

3221: SET double_check_flag = 'N'
3222: WHERE double_check_flag = 'Y'
3223: AND NOT EXISTS (
3224: SELECT NULL
3225: FROM po_requisition_headers RH
3226: WHERE RH.requisition_header_id =
3227: PPRL.requisition_header_id
3228: AND RH.last_update_date <= p_last_activity_date
3229: AND (RH.closed_code = 'FINALLY CLOSED'

Line 3512: FROM po_requisition_headers RH

3508: SET double_check_flag = 'N'
3509: WHERE double_check_flag = 'Y'
3510: AND NOT EXISTS (
3511: SELECT NULL
3512: FROM po_requisition_headers RH
3513: WHERE RH.requisition_header_id =
3514: PPRL.requisition_header_id
3515: AND RH.last_update_date <= p_last_activity_date
3516: AND (RH.closed_code = 'FINALLY CLOSED'

Line 3802: FROM po_requisition_headers PRH,

3798: INTO l_range_inserted
3799: FROM dual
3800: WHERE EXISTS (
3801: SELECT NULL
3802: FROM po_requisition_headers PRH,
3803: po_history_requisitions PHR
3804: WHERE PRH.segment1 = PHR.segment1
3805: AND PRH.type_lookup_code = PHR.type_lookup_code
3806: AND PHR.purge_name = p_purge_name

Line 3856: po_requisition_headers RH,

3852: p_purge_name,
3853: RH.org_id -- bug5446437
3854: FROM po_purge_req_list PRL,
3855: per_all_people_f PAPF,
3856: po_requisition_headers RH,
3857: po_requisition_lines RL
3858: WHERE PRL.requisition_header_id = RH.requisition_header_id
3859: AND RH.requisition_header_id = RL.requisition_header_id
3860: AND RH.preparer_id = PAPF.person_id

Line 4491: FROM po_requisition_headers RH

4487: l_progress := '020';
4488:
4489: --SQL What: Delete req headers with id within the range
4490: DELETE
4491: FROM po_requisition_headers RH
4492: WHERE EXISTS (
4493: SELECT NULL
4494: FROM po_purge_req_list PPRL
4495: WHERE PPRL.requisition_header_id =