Oracle Purchasing (PO) key requisition tables (4)

Categories: ERP Tables

PO_REQUISITION_HEADERS_ALL 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.
REQUISITION_HEADER_ID is the unique system–generated requisition number. REQUISITION_HEADER_ID is invisible to the user. SEGMENT1 is the number you use to identify the requisition in forms and reports. Oracle Purchasing generates SEGMENT1 using the PO_UNIQUE_IDENTIFIER_CONTROL table if you choose to let
Oracle Purchasing generate requisition numbers for you.
PO_REQUISITION_HEADERS_ALL is one of three tables storing requisition information. PO_REQUISITION_HEADERS_ALL corresponds to the Header region of the Requisitions window.
SEGMENT1 provides unique values for each row in the table in
addition to REQUISITION_HEADER_ID.

PO_REQUISITION_LINES stores information about requisition lines. You need one row for each requisition line you create. Each row contains the 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 identifies the purchase order shipment line on
which you placed the requisition. LINE_LOCATION_ID 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 multisourced this requisition line.
 

PO_REQUISITION_LINES is one of three tables storing requisition
information. This table corresponds to the Lines region of the
Requisitions window.

PO_REQ_DISTRIBUTIONS_ALL stores information about the accounting distributions associated with each requisition line. Each requisition line must have at least one accounting distribution. You need one row for each requisition distribution you create. Each row includes the Accounting Flexfield ID and requisition line quantity.
PO_REQ_DISTRIBUTIONS_ALL is one of three tables storing your requisition information. This table corresponds to the requisition Distributions window, accessible through the Requisitions window.

« « Oracle Purchasing (PO) key table – po_distributions_all (3)                        Retailers Show Signs of Intelligence » »

Comments are closed.