Tables related to the Purchasing Module
1. Purchase Requisition Tables
- PO_REQUISITION_HEADERS_ALL: Contains data of Requisition Headers
- PO_REQUISITION_LINES_ALL: Contains data of Requisition Lines
- PO_REQ_DISTRIBUTIONS_ALL: Contains accounting data of Requisition Lines
2. Purchase Order (PO) Tables
Using the below tables we can find the high level details of a Purchase Order:-
- PO_HEADERS_ALL:- contains the header information
- PO_LINES_ALL:- contains the lines details
- PO_LINE_LOCATIONS_ALL:- contains the shipment details
- PO_DISTRIBUTIONS_ALL:- contains the distribution details
- PO_RELEASES_ALL:- contains the information about blanket and planned purchase order releases
3. Receipt Tables
- RCV_SHIPMENT_HEADERS:-stores common information about the source of your receipts or expected receipts.
- RCV_SHIPMENT_LINES:-stores information about items that have been shipped and/or received from a specific receipt source
- RCV_TRANSACTIONS:-stores historical information about receiving transactions
Note: For more details refer to Oracle e:-Business Suite Electronic Technical Reference Manual that is available from Oracle MetaLink.
No comments:
Post a Comment