DBA Data[Home] [Help]

APPS.RCV_AP_PURGE_PVT dependencies on PO_HISTORY_RECEIPTS

Line 34: --Modifies: po_history_receipts

30: -----------------------------------------------------------------------
31: --Start of Comments
32: --Name: summarize_receipts
33: --Pre-reqs:
34: --Modifies: po_history_receipts
35: --Locks:
36: -- None
37: --Function:
38: -- Record necessary information for receipt lines that are about to be purged

Line 104: INSERT INTO po_history_receipts

100: -- table if the po line it associates with is in the
101: -- purge list
102: -- SQL Why: Need to record data in history table before actual
103: -- purge happens
104: INSERT INTO po_history_receipts
105: ( receipt_num,
106: shipment_num,
107: transaction_date,
108: vendor_id,