Tuesday, January 3, 2017

PURCHASE ORDER - IMPORTANT TABLES


                     PURCHASE ORDER - IMPORTANT TABLES

Table Name : PO_REQUISITION_HEADERS_ALL
Columns:

            
REQUISITION_HEADER_ID
            PREPARER_ID
            SEGMENT1
            SUMMARY_FLAG
            ENABLED_FLAG
Segment1:  Stores information about requisition headers. You need one row for each requisition header you create. Each row contains the requisition number, preparer, status, and description.SEGMENT1 is the number you use to identify the requisition in forms and reports (unique).
Table Name : PO_REQUISITION_LINES_ALL
Columns:
            
REQUISITION_LINE_ID
            REQUISITION_HEADER_ID
            LINE_NUM
            LINE_TYPE_ID
            CATEGORY_ID
            ITEM_DESCRIPTION
            UNIT_MEAS_LOOKUP_CODE
            UNIT_PRICE, QUANTITY
            DELIVER_TO_LOCATION_ID
            TO_PERSON_ID
            SOURCE_TYPE_CODE
Stores information about requisition-lines. Line number, item number, item category, item description, need–by date, deliver–to location, item quantities, units, prices, requestor, notes, and suggested supplier information for the requisition line. LINE_LOCATION_ID - Purchase order shipment line on which you placed the requisition. It is null if you have not placed the requisition line on a purchase order. BLANKET_PO_HEADER_ID and BLANKET_PO_LINE_NUM store the suggested blanket purchase agreement or CATALOG quotation line information for the requisition line. PARENT_REQ_LINE_ID contains the REQUISITION_LINE_ID from the original requisition line if you exploded or multi-sourced this requisition line.
Table Name : PO_HEADERS_ALL
Columns:
            
PO_HEADER_ID
            AGENT_ID
            TYPE_LOOKUP_CODE
            SEGMENT1
            SUMMARY_FLAG
            ENABLED_FLAG
Information for your purchasing documents. There are six types of documents that use PO_HEADERS_ALL. RFQs, Quotations, Standard purchase orders, planned purchase orders, Blanket purchase orders, Contracts can uniquely identify a row in PO_HEADERS_ALL using SEGMENT1 and TYPE_LOOKUP_CODE or using PO_HEADER_ID.BLANKET_TOTAL_AMOUNT for blanket purchase orders or contract purchase orders. If we use copy document Oracle Purchasing stores the foreign key to your original RFQ in FROM_HEADER_ID.
Table Name : PO_LINES_ALL
Columns:
            
PO_LINE_ID
            PO_HEADER_ID
            LINE_TYPE_ID
            LINE_NUM
Stores current information about each purchase order line. CONTRACT_NUM reference a contract purchase order from a standard purchase order line.

Table Name : PO_VENDORS
Columns:
            
VENDOR_ID
            VENDOR_NAME
            SEGMENT1
            SUMMARY_FLAG
            ENABLED_FLAG
Information about your suppliers. Purchasing, Receiving, Payment, Accounting, Tax, Classification, and General Information.
Table Name : PO_VENDOR_SITES_ALL
Columns:

            
VENDOR_SITE_ID
            VENDOR_ID
            VENDOR_SITE_CODE
Information about your supplier sites. A row for each supplier site you define. Each row includes the site address, supplier reference, purchasing, payment, bank, and general information. Oracle Purchasing uses this information to store supplier address information.

Table Name : PO_DISTRIBUTIONS_ALL
Columns:
            
PO_DISTRIBUTION_ID
            PO_HEADER_ID
            PO_LINE_ID
            LINE_LOCATION_ID
            SET_OF_BOOKS_ID
            CODE_COMBINATION_ID
            QUANTITY_ORDERED
            DISTRIBUTION_NUM
Contains accounting distribution information for a purchase order shipment line. You need one row for each distribution line you attach to a purchase order shipment.
There are 4 - types of documents using distributions in Oracle Purchasing:            · Standard Purchase Orders
            · Planned Purchase Orders
            · Planned Purchase Order Releases
            · Blanket Purchase Order Releases

Includes the Destination Type, Requestor ID, Quantity Ordered and Deliver–To Location for the distribution.


Table Name : PO_RELEASES_ALL
Columns:
            
PO_RELEASE_ID
            PO_HEADER_ID
            RELEASE_NUM
            AGENT_ID
            RELEASE_DATE
Contains information about blanket and planned purchase order releases. You need one row for each release you issue for a blanket or planned purchase order. Each row includes the buyer, date, release status, and release number. Each release must have at least one purchase order shipment.
Table Name : PO_VENDOR_CONTACTS
Columns:

            
VENDOR_CONTACT_ID
            VENDOR_SITE_ID
Stores information about contacts for a supplier-site. You need one row for each supplier contact you define.
Each row includes the contact name and site.

Table Name : PO_ACTION_HISTORY
Columns:
            
OBJECT_ID
            OBJECT_TYPE_CODE
            OBJECT_SUB_TYPE_CODE
            SEQUENCE_NUM
Information about the approval and control history of your purchasing documents. There is one record in this table for each approval or control action an employee takes on a purchase order, purchase agreement, release, or requisition.

            
· OBJECT_ID - Document header Identifier
            · OBJECT_TYPE_CODE - Document Type
            · OBJECT_SUB_TYPE_CODE - Document subtype
            · SEQUENCE_NUM - Sequence of the approval or control action for a document.

Table Name : PO_REQ_DISTRIBUTIONS_ALL
Columns:

            
DISTRIBUTION_ID
            REQUISITION_LINE_ID
            SET_OF_BOOKS_ID
            CODE_COMBINATION_ID
            REQ_LINE_QUANTITY
            DISTRIBUTION_NUM
Stores information about the accounting distributions associated with each requisition line.
Table Name : PO_LINE_LOCATIONS_ALL
Columns:
            
LINE_LOCATION_ID   
            LAST_UPDATE_DATE
            LAST_UPDATED_BY
            PO_HEADER_ID
            PO_LINE_ID
            SHIPMENT_TYPE
Contains information about purchase order shipment schedules and blanket agreement price breaks.
 You need one row for each schedule or price break you attach to a document line.
There are 7- Types of documents that use shipment schedules:            · RFQs
            · Quotations
            · Standard Purchase Orders
            · Planned Purchase Orders
            · Planned Purchase Order Releases
            · Blanket Purchase Orders
            · Blanket Purchase Order Releases
Each row includes the location, quantity, and dates for each shipment schedule. Oracle Purchasing uses this information to record delivery schedule information for purchase orders, and price break information for blanket purchase orders, quotations and RFQs.
Purchase Order - Related Tables Information

PO_REQUISITION_HEADESR_ALL
PO_REQUISITION_LINES_ALL
When you raise the Requisition these tables effected. (PO_REQUISITION_HEADER_ID) is the join between the tables
PO_REQ_DISTRIBUTION_ALL
It distributes the Requisition Account information.
PO_HEADERS_ALL (PO_HEADER_ID)
PO_LINES_ALL
When PO Created PO # stored in tables. (PO_HEADER_ID) is the join for tables
PO_DISTRIBUTIONS_ALL
It will distribute the PO # Account information
PO_ACTION_HISTORY
Here you can get Approvals notification Status
PO_VENDORS_ALL(VENDOR_ID)
PO_VENDOR_SITES_ALL
(VENDOR_SITE_ID)
PO_VENDOR_CONTACTS_ALL 
(VENDOR_CONTACT_ID)
Contacts Vendor, Vendor site and contact information (Vendor_id, Vendor_contact_id, VEDNOR_SITE_ID)
RCV_SHIPMENT_HEADERS_ALL
(SHIPMENT_HEADER_ID)
Common information about the source of your receipts or expected receipts
RCV_SHPMENT_LINES_ALL
When you issue the receipt The recipient number, Shipment location stores in the table.
RCV_TRANSACTIONS
(TRANSACTION_ID)
MTL_MATERIAL_TRANSACTIONS 
(TRANSACTION_ID)
Stores material transaction information (Transaction_id)
PO_RELEASE_ALL
To see which purchase order is released.
PO_AGENTS
Contains information about buyers and purchasing managers.
PO_NOTIFICATION_CONTROLS
Contains information about the notification control rules for blanket, planned, and contract purchase orders.
PO_APPROVAL_LIST_HEADERS
List of approvers for the purchasing document. Used for requisition approvals only
PO_APPROVAL_LIST_LINES
Approval list lines for the requisition approval list.
PO_POSITION_CONTROLS_ALL
assignment of control groups to jobs and/or positions
PO_DOCUMENT_TYPES_ALL_B
Default, control, and option information you provide to customize
PO_CONTROL_GROUPS_ALL
Control groups you use in your business
PO_RFQ_VENDORS
Information about the set of suppliers assigned to a request for quotation (RFQ)
PO_VENDOR_LIST_HEADERS
(VENDOR_LIST_HEADER_ID)
Stores information about supplier quotation lists you create.
FINANCIALS_SYSTEM_PARAMS_ALL
This Tables stores common and default information between AP and PO

No comments:

Post a Comment

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...