APPS.PO_AP_PURGE_PVT dependencies on PO_HISTORY_REQUISITIONS

Line 1371: FROM po_history_requisitions

1367:
1368: l_progress := '030';
1369:
1370: DELETE
1371: FROM po_history_requisitions
1372: WHERE purge_name = p_purge_name;
1373:
1374: l_progress := '040';
1375:

Line 3709: --Modifies: po_history_requisitions

3705: -----------------------------------------------------------------------
3706: --Start of Comments
3707: --Name: summarize_reqs
3708: --Pre-reqs:
3709: --Modifies: po_history_requisitions
3710: --Locks:
3711: -- None
3712: --Function:
3713: -- Record necessary information for requisitions that are about to be purged

Line 3803: po_history_requisitions PHR

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
3807: AND PRH.requisition_header_id BETWEEN l_range_low

Line 3836: INSERT INTO po_history_requisitions

3832:
3833: -- SQL What: Insert requisition information into history tables
3834: -- SQL Why: Summarization functionality
3835:
3836: INSERT INTO po_history_requisitions
3837: ( segment1,
3838: type_lookup_code,
3839: creation_date,
3840: requisition_total,