Order Management Technical Document
Order Management
Order Headers
OE_ORDER_HEADERS_ALL
HEADER_ID
ORG_ID
ORDER_NUMBER
ORDER_TYPE_ID OE_TRNSACTION_TYPES_ALL.TRANSACTION_TYPE_ID
ORDER_SOURCE_ID Order Source from OE_ORDER_SOURCES
ORIG_SYS_DOCUMENT_REF Quote Number.Version for Sales & Mkting Quote
OE_ORDER_HEADERS_ALL for OM
SOURCE_DOCUMENT_ID Order Header ID from which order is Copied
PRICE_LIST_ID OE_PRICE_LISTS.PRICE_LIST_ID
ORDERED_DATE
REQUEST_DATE
BOOKED_DATE
TRANSACTIONAL_CURR_CODE
CUSTOMER_PO_NUMBER Mandatory id specified in Transaction Type
PAYMENT_TERM_ID RA_TERMS.TERM_ID
SOLD_TO_ORG_ID CUSTOMER_ID or HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
SHIP_TO_ORG_ID HZ_CUST_SITE_USES_ALL.SITE_USE_ID
INVOICE_TO_ORG_ID HZ_CUST_SITE_USES_ALL.SITE_USE_ID
CANCELLED_FLAG
OPEN_FLAG
BOOKED_FLAG
SALESREP_ID JTF_RS_SALESREPS.SALESREP_ID
ORDER_CATEGORY_CODE ORDER, RETURN, MIXED
FLOW_STATUS_CODE ENTERED, BOOKED, CLOSED, CANCELLED
Order Lines
OE_ORDER_LINES_ALL
LINE_ID
ORIG_SYS_DOCUMENT_REF OE_ORDER_HEADERS_ALL50479
SOURCE_DOCUMENT_ID 50462
ORIG_SYS_LINE_REF OE_ORDER_LINES_ALL59908
SOURCE_DOCUMENT_LINE_ID 59893
HEADER_ID
LINE_TYPE_ID OE_TRNSACTION_TYPES_ALL.TRANSACTION_TYPE_ID
LINE_NUMBER
ORDERED_ITEM MTL_SYSTEM_ITEMS.SEGMENT1
REQUEST_DATE
PROMISE_DATE
SCHEDULE_SHIP_DATE
CANCELLED_QUANTITY
SHIPPED_QUANTITY
ORDERED_QUANTITY
INVOICED_QUANITITY
SHIP_FROM_ORG_ID WAREHOUSE_ID or INVENTORY ORGANIZATION ID
SHIP_TO_ORG_ID HZ_CUST_SITE_USES_ALL.SITE_USE_ID
INVOICE_TO_ORG_ID HZ_CUST_SITE_USES_ALL.SITE_USE_ID
SOLD_TO_ORG_ID CUSTOMER_ID or HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
PRICE_LIST_ID QP_LIST_HEADERS_B.PRICE_LIST_ID
INVENTORY_ITEM_ID MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID
PAYMENT_TERM_ID RA_TERMS.TERM_ID
UNIT_SELLING_PRICE
UNIT_LIST_PRICE OE_PRICE_LIST_LINES
TAX_VALUE
VISIBLE_DEMAND_FLAG
LINE_CATEGORY_CODE ORDER, RETURN
SOURCE_TYPE_CODE INTERNAL, EXTERNAL
CANCELLED_FLAG
OPEN_FLAG
BOOKED_FLAG
DROP_SHIP_FLAG
SALESREP_ID JTF_RS_SALESREPS.SALESREP_ID
ORDER_SOURCE_ID
FLOW_STATUS_CODE
SPLIT_FROM_LINE_ID
MTL_ONHAND_QUANTITIES
INVENTORY_ITEM_ID
ORGANIZATION_ID
TRANSACTION_QUANTITY
SUBINVENTORY_CODE
Order Price Adjustments & Line Price Adjustments
OE_PRICE_ADJUSTMENTS
This table is used to store price adjustments that have been applied to an order or a line. The column automatic flag indicates if the adjustment was applied automatically or manually. Manual discouts are created with applied_Flag = Y.
Order Sales Credits
OE_SALES_CREDITS
SALES_CREDIT_ID
HEADER_ID
LINE_ID
SALES_CREDIT_TYPE_ID
QUOTA_FLAG
SALESREP_ID
PERCENT
Line Sales Credits
OE_SALES_CREDITS
Order Pricing Attributes
OE_ORDER_PRICE_ATTRIBS
Line Pricing Attributes
OE_ORDER_PRICE_ATTRIBS
Order Adjustment Attributes
OE_PRICE_ADJ_ATTRIBS
Line Adjustment Attributes
OE_PRICE_ADJ_ATTRIBS
Order Adjustment Associations
OE_PRICE_ADJ_ASSOCS
Line Adjustment Associations
OE_PRICE_ADJ_ASSOCS
Lot Serial Numbers
OE_LOT_SERIAL_NUMBERS
|
|
|
|
|
|
|
|
|
Attachments
FND_ATTACHED_DOCUMENTS
ATTACHED_DOCUMENT_ID
DOCUMENT_ID
ENTITY_NAME OE_ORDER_LINES, OE_ORDER_HEADERS
PK1_VALUE LINE_ID, HEADER_ID
AUTOMATICALLY_ADDED_FLAG
SELECT FD.DOCUMENT_ID
,FD.DESCRIPTION
,FD.MEDIA_ID
,FDST.SHORT_TEXT
FROM FND_DOCUMENTS_TL FD
,FND_ATTACHED_DOCUMENTS FAD
,FND_DOCUMENTS_SHORT_TEXT FDST
,OE_ORDER_LINES_ALL OL
WHERE FAD.DOCUMENT_ID = FD.DOCUMENT_ID
AND FDST.MEDIA_ID = FD.MEDIA_ID
AND OL.LINE_ID = FAD.PK1_VALUE
AND OL.LINE_ID = 59851;
Demand:
VISIBLE_DEMAND_FLAG in OE_ORDER_LINES_ALL.
In Order Management Application (Release 11i), Demand Interface is no longer available. Order lines will serve as demand in Order Management Applications. Every line which has the VISIBLE_DEMAND_FLAG = 'Y', will be made available as Demanded to planning. Every line which is Scheduled will be visible to planning as Demanded. So there is no Demand Interface Program, to put the order lines in the demand tables. The table MTL_DEMAND is obsolete. Demand is a process which makes an order line visible to MRP for planning purposes. From Release 11i, Scheduling is an engine owned by MRP.OE_ORDER_LINES will have a flag called VISIBLE_DEMAND_FLAG. If set to 'Yes', the MRP can see the line, if it is set to 'No' the line will just be ignored when performing Planning. When a line is scheduled it becomes visible to MRP, if theVISIBLE_DEMAND_FLAG is set to 'Yes'.
Once the Order is saved, data goes to MTL_SALES_ORDERS table:
MTL_SALES_ORDERS exists for the purpose of mapping sales orders between other applications and Inventory. MTL_SALES_ORDERS is a key flexfield table with no structure defining column or set defining column. The flexfield code for this table is MKTS. Only one structure for the flexfield may be defined for any installation of Inventory. Inventory demand interface and demand manager will validate sales orders on segment values, and will create a new SALES_ORDER_ID when necessary.
MTL_SALES_ORDERS
SALES_ORDER_ID NOT NULL NUMBER
SEGMENT1 VARCHAR2 (40) => ORDER_NUMBER
SEGMENT2 VARCHAR2 (40) => ORDER_TYPE_ID
SEGMENT3 VARCHAR2 (40)
This table stores reservation information. Each record is a reservation that ties an item/organization combination with a demand source and a supply source. Demand source information comprises demand source type (Sales Order, Account, Account Alias, Inventory), demand source header, demand source line and demand source name. Supply source information comprises supply source type (Inventory, WIP jobs), supply source header, supply source line, supply source name and inventory controls (revision, lot, subinventory, locator).
Shipping:
Pick Release:
WSH_PICKING_BATCHES
The information filled in the Pick Release form is inserted in this table. System creates one batch for the condition you specify in Pick Release Form.
BATCH_ID
CUSTOMER_ID HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
ORDER_HEADER_ID
After Pick Release records goes to WSH_DELIVERY_DETAILS for each line, which is picked or backordered. If Autocreate Deliveries is set to set ‘YES’ then record also goes to WHS_NEW_DELIVERIES and WSH_DELIVERY_ASSIGNMENTS but Pick Release is only Reserving the Items against particular Sales Order Line.
WSH_DELIVERY_DETAILS:
DELIVERY_DETAIL_ID
SOURCE_CODE ‘OE’
SOURCE_HEADER_NUMBER Order Number
SOURCE_LINE_NUMBER
SOURCE_HEADER_ID Order Header ID
SOURCE_LINE_ID Order Line ID
SOURCE_HEADER_TYPE_ID Order Type ID
SOURCE_HEADER_TYPE_NAME Order Type Name
CUST_PO_NUMBER Customer PO Number
DELIVER_TO_LOCATION_ID HZ_LOCATIONS.LOCATION_ID
SHIP_TO_LOCATION_ID HZ_LOCATIONS.LOCATION_ID
ORGANIZATION_ID
SHIP_FROM_LOCATION_ID WAREHOUSE_ID
CUSTOMER_ID HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
INVENTORY_ITEM_ID & ITEM_DESCRIPTION
REQUESTED_QUANTITY The qty. requested for Pick Release. If the program reserves partial qty. then it splits the Lines in the Order and also inserts two lines in WSH_DELIVERY_DETAILS. The qty. available for reservation will be REQUESTED_QUANTITY for First record and balance qty. will be REQUESTED_QUANTITY for other record.
PICKED_QUANTITY
SHIPPED_QUANTITY After Ship Confirm Shipped qty. is updated
UNIT_PRICE
CURRENCY_CODE
MOVE_ORDER_LINE_ID
SHIP_TO_SITE_USE_ID
INV_INTERFACED_FLAG
SPLIT_FROM_DELIVERY_DETAIL_ID (For Backordered Line)
ORG_ID
CUSTOMER_ITEM_ID
SHIP_METHOD_CODE
RELEASED_STATUS (B=Backordered, C=Shipped, D=Cancelled,
N=Not ready for release, R=Ready to release,
S=Released to Warehouse, X=Not Applicable, Y=Staged)
Reservations:
MTL_RESERVATIONS
This table stores reservation information. Each record is a reservation that ties and item/organization combination with a demand source and a supply source. Demand source information comprises demand source type (Sales Order, Account, Account Alias, Inventory), demand source header, demand source line and demand source name. Supply source information comprises supply source type (Inventory, WIP jobs), supply source header, supply source line, supply source name and inventory controls (revision, lot, subinventory, locator).
INVENTORY_ITEM_ID
ORGANIZATION_ID
DEMAND_SOURCE_LINE_ID Order Line ID
DEMAND_SOURCE_DELIVERY
RESERVATION_QUANTITY
SUBINVENTORY_CODE
Create Deliveries
After Auto creating the Delivery, records goes to WSH_NEW_DELIVERIES andWSH_DELIVERY_ASSIGNMENTS. If Autocreate Deliveries is set to set ‘YES’ then record goes to both the tables after Pick Release.
WSH_NEW_DELIVERIES: Stores the Delivery Information.
DELIVERY_ID
NAME
STATUS_CODE Delivery shipping status (OP=Open, CL=Closed,
IT= In-Transit)
CUSTOMER_ID
SHIP_METHOD_CODE
DELIVERY_TYPE Type of delivery - STANDARD, CONSOLIDATED
ORGANIZATION_ID
WSH_DELIVERY_ASSIGNMENTS: Link between WSH_DELIVERY_DETAILS &WSH_NEW_DELIVERIES. Assigns delivery details to a delivery and/or a parent delivery detail (LPN).
DELIVERY_ASSIGNMENT_ID
DELIVERY_ID Foreign Key to WSH_NEW_DELIVERIES
DELIVERY_DETAIL_ID Foreign key to WSH_DELIVERY_DETAILS
Ship Confirm
After Ship Confirm, Deliveries gets Closed i.e. STATUS_CODE inWSH_NEW_DELIVERIES changes to ‘CL’ and CONFIRMED_BY field gets updated with Apps User Name. RELEASE_STATUS in WSH_DELIVERY_DETAILS changes to ‘C’. SHIPPED_QUANTITY in WSH_DELIVERY_DETAILS and SHIPPED_QUANTITY inOL_ORDER_LINES_ALL get updated with quantity shipped.
Ship Method
SELECT LOOKUP_CODE,
MEANING,
DESCRIPTION,
START_DATE_ACTIVE,
END_DATE_ACTIVE,
ENABLED_FLAG,
LOOKUP_TYPE
FROM FND_LOOKUP_VALUES_VL
WHERE (nvl('', territory_code) = territory_code or territory_code is null)
and (LOOKUP_TYPE LIKE 'SHIP_METHOD')
and (VIEW_APPLICATION_ID=3)
and (SECURITY_GROUP_ID=0)
order by LOOKUP_CODE
Inventory Interface
Trips:
WSH_TRIPS
TRIP_ID
NAME
PLANNED_FLAG Y if Trip is planned.
STATUS_CODE OP - Open, IT - In -transit, CL - Closed
VEHICLE_ITEM_ID MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID
VEHICLE_NUMBER
CARRIER_ID
SHIP_METHOD_CODE
ROUTE_ID
WSH_TRIP_STOPS
STOP_ID
TRIP_ID
STOP_LOCATION_ID
STATUS_CODE
WSH_DELIVERY_LEGS
DELIVERY_LEG_ID
DELIVERY_ID WSH_NEW_DELIVERIES.DELIVERY_ID
PICK_UP_STOP_ID WSH_TRIP_STOPS.STOP_ID
DROP_OFF_STOP_ID
Rules
WSH_PICKING_RULES
WSH_PICK_GROUPING_RULES
WSH_PICK_SEQUENCE_RULES
Inventory Interface
Inventory Interface puts the Deliveries, which are Closed and Ship Confirmed inMTL_MATERIAL_TRANSACTIONS_TEMP. Records are processed from this table into Inventory through the transaction processor.
MTL_MATERIAL_TRANSACTIONS
TRANSACTION_ID
TRANSACTION_TYPE_ID
TRANSACTION_SOURCE_TYPE_ID
TRANSACTION_ACTION_ID
INVENTORY_ITEM_ID
SUBINVENOTRY_CODE
TRANSACTION_QUANTITY -ve Qty for Sales Order Issue
TRANSACTION_REFERENCE ORDER HEADER ID
SOURCE_LINE_ID ORDER LINE ID
PICKING_LINE_ID DELIVERY_DETAIL_ID
SHIPMENT_NUMBER DELIVERY ID
INVOICED_FLAG
SOURCE_CODE ORDER ENTRY
FREIGH_CODE SHIP METHOD
Receivables Interface & Data flow from Order Management to ReceivablesRA_INTERFACE_LINES_ALL and RA_INTERFACE_SALESCREDITS_ALL
LINE_TYPE For Sales Order Line ‘LINE’
For Freight Charges ‘FREIGHT’
For Tax ‘TAX’
SALES_ORDER OE_ORDER_HEADERS.ORDER_NUMBER
SALES_ORDER_LINE OE_ORDER_LINES.LINE_NUMBER
PURCHASE_ORDER OE_ORDER_HEADERS.LINES.CUST_PO_NUMBER
INTERFACE_LINE_ATTRIBUTE2 Order Type Name
INTERFACE_LINE_ATTRIBUTE6 OE_ORDER_LINES.LINE_ID
INTERFACE_LINE_ATTRIBUTE10 OE_ORDER_LINES.SHIP_FROM_ORD_ID
INTERFACE_LINE_ATTRIBUTE12 OE_ORDER_LINES.shipment_number
INTERFACE_LINE_ATTRIBUTE13 OE_ORDER_LINES.option_number
INTERFACE_LINE_ATTRIBUTE14 OE_ORDER_LINES.service_number
Service Interface & Data flow from OM to Installed Base
Internal Order:
PO_REQUISITION_HEADERS_ALL
REQUISITION_HEADER_ID
SEGMENT1 Requisition Number
AUTHORIZATION_STATUS APPROVED, IN PROCESS, INCOMPLETE
TYPE_LOOKUP_CODE INTERNAL, PURCHASE
TRANSFERRED_TO_OE_FLAG Y
ORG_ID
PO_REQUISITION_LINES_ALL
REQUISITION_LINE_ID
REQUISITION_HEADER_ID
LINE_NUM
UNIT_PRICE
QUANTITY
ITEM_DESCRIPTION
ITEM_ID
DESTINATION_TYPE_CODE INVENTORY, EXPENSE, SHOP FLOOR
DESTINATION_ORGANIZATION_ID
DESTINATION_SUBINVENTORY
DELIVER_TO_LOCATION_ID Internal Location which is attached to Internal Customer
SOURCE_ORGANIZATION_ID
SOURCE_SUBINVENTORY
SOURCE_TYPE_CODE INVENTORY, VENDOR
NEED_BY_DATE
ORG_ID
Item :
MTL_SYSTEM_ITEMS_B
PURCHASING_ITEM_FLAG
PURCHASING_ENABLED_FLAG
CUSTOMER_ORDER_FLAG
CUSTOMER_ORDER_ENABLED_FLAG
INTERNAL_ORDER_FLAG
INTERNAL_ORDER_ENABLED_FLAG
SHIPPABLE_ITEM_FLAG
INVENTORY_ITEM_FLAG
HR_LOCATIONS_ALL
LOCATION_ID
INVENTORY_ORGANIZATION_ID
PO_LOCATION_ASSOCIATIONS_ALL
LOCATION_ID
CUSTOMER_ID
ADDRESS_ID
SITE_USE_ID
ORGANIZATION_ID
PO_SYSTEM_PARAMETERS_ALL
ORDER_TYPE_ID
ORDER_SOURCE_ID
ORG_ID
OE_ORDER_HEADERS_IFACE_ALL
OE_ORDER_LINES_IFACE_ALL
Drop Shipment:
Purchase Release inserts the records in Requisition Interface tables. Purchase Releasepicks the records from OE_ORDER_LINES_ALL for Booked order whereSOURCE_TYPE_CODE is ‘EXTERNAL’. After running the Requisition Import (this is automatically run by Workflow Background Process for the Purchase Released Orders) record is inserted in OE_DROP_SHIP_SOURCES andPO_REQUISITION_HEADERS_ALL & PO_REQUISITION_LINES_ALL. Requisition Import Submits new request “Create Releases request” which Releases the Purchase Order i.e. putting the records in PO_HEADERS_ALL and PO_LINES_ALL.
INTERFACE_SOURCE_CODE in PO_REQUISITION_HEADERS_ALL refers to ‘ORDER ENTRY’ and INTERFACE_SOURCE_LINE_ID refers to DROP_SHIP_SOURCE_ID inOE_DROP_SHIP_SOURCES. Also PO_HEADER_ID in PO_HEADERS_ALL andPO_LINE_ID in PO_LINES_ALL is stored in OE_DROP_SHIP_SOURCES creating the Purchase Order from Requisitions. Material can be received on the PO after the PO approval. Records do not directly go to Receipt Table (RCV_SHIPMENT_HEADERS &RCV_SHIPMENT_LINE). Once the PO is approved, record goes to Shipment Schedule table (RCV_LINE_LOCATIONS_ALL). The LINE_LOCATION_ID is the Primary key for this table and it is also stored in OE_DROP_SHIP_SOURCES.
After the Receipt of the Material in Logical Organization, 2 records gets inserted inMTL_MATERIAL_TRANSACTIONS. One record is of Receipt of the Material (+ve Qty.) and another record is of Sales Order Issue (-ve entry). The Order line automatically Ship Confirmed after successful receipt of the Material.
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
LINE_ID
HEADER_ID
ORDERED_QUANTITY
INVENTORY_ITEM_ID
LINE_CATEGORY_CODE ORDER
SOURCE_TYPE_CODE EXTERNAL
SCHEDULE_SHIP_DATE
SOLD_FROM_ORG_ID
PO_REQUISITIONS_INTERFACE_ALL
PO_REQUISITION_HEADERS_ALL
REQUISITION_HEADER_ID
SEGMENT1
AUTHORIZATION_STATUS
INTERFACE_SOURCE_CODE ORDER ENTRY
PO_REQUISITION_LINES_ALL
REQUISITION_LINE_ID
REQUISITION_HEADER_ID
ITEM_DESCRIPTION & ITEM_ID
UNIT_PRICE
QUANTITY
SOURCE_TYPE_CODE VENDOR
NEED_BY_DATE
DESTINATION_TYPE_CODE INVENTORY
DESTINATION_ORGANIZATION_ID
VENDOR_ID
VENDOR_SITE_ID
OE_DROP_SHIP_SOURCES
DROP_SHIP_SOURCE_ID
HEADER_ID
LINE_ID
DESTINATION_ORGANIZATION_ID
REQUISITION_HEADER_ID
REQUISITION_LINE_ID
PO_HEADER_ID
PO_LINE_ID
LINE_LOCATION_ID
PO_HEADERS_ALL
PO_HEADER_ID
TYPE_LOOKUP_CODE STANDARD
SEGMENT1
VENDOR_ID
VENDOR_SITE_ID
SHIP_TO_LOCATION_ID
BILL_TO_LOCATION_ID
CURRENCY_CODE
AUTHORIZATION_STATUS
ORG_ID
PO_LINES_ALL
PO_LINE_ID
PO_HEADER_ID
ITEM_ID
ITEM_DESCRIPTION
LIST_PRICE_PER_UNIT
LIST_PRICE
QUANTITY
ORG_ID
PO_LINE_LOCATIONS_ALL
RCV_SHIPMENT_LINES
RCV_TRANSACTIONS
select req_h.segment1 REQUISITION_NUMBER
,oh.header_id
,oh.order_number ORDER_NUMBER
,ol.line_id
,ph.segment1 PO_NUMBER
from po_requisition_headers_all req_h
,po_headers_all ph
,oe_drop_ship_sources od
,oe_order_lines_all ol
,oe_order_headers_all oh
where req_h.interface_source_code = 'ORDER ENTRY'
and req_h.interface_source_line_id = od.drop_ship_source_id
and od.po_header_id = ph.po_header_id
and od.line_id = ol.line_id
and ol.header_id = oh.header_id;
Returns:
MTL_SO_RMA_INTERFACE & MTL_SO_RMA_RECEIPTS tables are obsolete. Once the RMA is booked, material can be received on RMA ifOE_ORDER_LINES_ALL.BOOKED_FLAG is ‘Y’ andOE_ORDER_LINES_LINES.FLOW_STATUS_CODE is 'AWAITING_RETURN'. Also the Receipts are stored in table RCV_SHIPMENT_HEADERS & RCV_SHIPMENT_LINES.
OE_ORDER_LINES_ALL
ORDERED_QUANTITY
SOLD_TO_ORG_ID
SHIP_TO_ORG_ID
INVOICE_TO_ORG_ID
INVENTORY_ITEM_ID
PRICE_LIST_ID
LINE_CATEGORY_CODE RETURN
RETURN_CONTEXT INVOICE, ORDER, PO,
RETURN_ATTRIBUTE1
.
.
.
RETURN_ATTRIBUTE15
RETURN_REASON_CODE
REFERENCE_HEADER_ID HEADER_ID, which is being returned
REFERENCE_LINE_ID LINE_ID, which is being returned
REFERENCE_CUSTOMER_TRX_LINE_ID
OE_ORDER_HEADERS_ALL
ORDER_CATEGORY_CODE RETURN, MIXED
RCV_SHIPMENT_HEADERS
SHIPMENT_HEADER_ID
RECEIPT_SOURCE_CODE CUSTOMER
ORGANIZATION_ID
RECEIPT_NUM
CUSTOMER_ID HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
RCV_SHIPMENT_LINES
SHPMENT_LINE_ID
SHIPMENT_HEADER_ID
LINE_NUM
QUANTITY_RECEIVED
UNIT_OF_MEADSURE
ITEM_DESCRIPTION
ITEM_ID OE_ORDER_LINES.INVENTORY_ITEM_ID
SHIPMENT_LINE_STATUS_CODE FULLY RECEIVED, PARTIALLY RECEIVED
SOURCE_DOCUMENT_CODE RMA
DESTINATION_TYPE_CODE INVENTORY
TO_ORGANIZATION_ID OE_ORDER_HEADERS.SHIP_FROM_ORG_ID
TO_SUBINVENTORY
OE_ORDER_HEADER_ID
OE_ORDER_LINE_ID
MTL_MATERIAL_TRANSACTIONS_TEMP
MTL_MATERIAL_TRANSACTIONS
RA_INTERFACE_LINES_ALL
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
ATO Cycle:
BOM_BILL_OF_MATERIALS
BILL_SEQUENCE_ID
ASSEMBLY_ITEM_ID
ORGANIZATION_ID
BOM_INVENTORY_COMPONENTS
COMPONENT_SEQUENCE_ID
OPERATION_SEQUENCE_NUM
COMPONENT_ITEM_ID
COMPONENT_QUANTITY
OPTIONAL 1=Checked, 2=Not Checked
MUTUALLY_EXCLUSIVE_OPTION 1=Checked, 2=Not Checked
BILL_SEQUENCE_ID
OE_ORDER_HEADERS_ALL
ORDER_TYPE_ID
OE_ORDER_LINES_ALL
LINE_ID
HEADER_ID
LINE_TYPE_ID
LINE_NUMBER
ORDERED_QUANTITY
INVENTORY_ITEM_ID
UNIT_SELLING_PRICE
UNIT_LIST_PRICE
TOP_MODEL_LINE_ID LINE_ID of the Model stored for each lineincluding for Model that is same LINE_ID.
(Identifier of configuration top parent line)
LINK_TO_LINE_ID LINE_ID of the CLASS to which the OPTION is linked. For MODEL it is NULL. (Identifier of immediate parent component line)
COMPONENT_SEQUENCE_ID Bill of materials component (option) or bill (top model)
COMPONENT_CODE Identifier of component within an exploded bill
ITEM_TYPE_CODE MODEL, CLASS, OPTION, CONFIG
OPTION_NUMBER Identifier for an option or a class within a model (1,2,3,4..) 0 for CONFIG.
ATO_LINE_ID LINE_ID of the Model stored for each line including for Model that is same LINE_ID.
CONFIG_HEADER_ID System-generated identifier for Oracle Configurator reference
CONFIG_REV_NBR System-generated identifier for Oracle Configurator reference
WSH_DELIVERY_DETAILS (After Import Delivery Lines)
DELIVERY_DETAIL_ID
TOP_MODEL_LINE_ID
ATO_LINE_ID
ITEM_ID ITEM ID of CONFIG Item.
WIP_JOB_SCHEDULE_INTERFACE
WIP_DISCRETE_JOBS
WIP_ENTITY_ID
ORGANIZATION_ID
SOURCE_LINE_ID Order LINE_ID of Item of which Item Type isCONFIG
PRIMARY_ITEM_ID INVENTORY_ITEM_ID of Item in Order of which Item Type is CONFIG
CLASS_CODE Discrete
START_QUANTITY
QUANTITY_COMPLETED
COMMON_BON_SEQENCE_ID Assembly identifier used as bill of material reference for explosions of nonstandard job
BOM_REVISION BOM revision for the primary assembly
COMPLETION_SUBINVENTORY
STATUS_TYPE (Lookup Type = WIP_JOB_STATUS)
1=Unreleased
3=Released
4=Complete
12=Closed
WIP_REQUIREMENT_OPERATIONS
INVENTORY_ITEM_ID
ORGANIZATION_ID
WIP_ENTITY_ID
OPERATION_SEQUENCE_NUM
COMPONENT_SEQUENCE_ID
WIP_SUPPLY_TYPE
REQUIRED_QUANTITY
QUANTITY_ISSUED
QUNTITY_PER_ASSEMBLY
SEGMENT1 ITEM
WIP_MOVE_TRANSACTIONS
TRANSACTION_ID
WIP_ENTITY_ID
PRIMARY_ITEM_ID
TRANSACTION_DATE
TRANSACTION_QUANTITY
WSH_DELIVERY_ASSIGNMENTS
DELIVERY_ASSIGNMENT_ID
DELIVERY_ID
DELIVERY_DETAIL_ID
WSH_NEW_DELIVERIES
DELIVERY_ID
NAME
STATUS_CODE
Pricing:
Qualifiers & Modifiers:
QP_LIST_HEADERS
LIST_HEADER_ID
CURRENCY_CODE
AUTOMATIC_FLAG Y/N
LIST_TYPE_CODE PRO
NAME
DESCRIPTION
ACTIVE_FLAG
QP_LIST_LINES
LIST_LINE_ID
LIST_HEADER_ID
LIST_LINE_TYPE_CODE DIS, FREIGHT_CHARGE, SUR..
MODIFIER_LEVEL_CODE LINE, LINEGROUP, ORDER
ARITHMETIC_OPERATOR %, AMT, LUMPSUM, NEWPRICE, UNIT_PRICE
OPERAND
QP_PRICING_ATTRIBUTES
PRICING_ATTRIBUTE_ID
LIST_LINE_ID
LIST_HEADER_ID
PRODUCT_ATTRIBUTE_CONTEXT ITEM
PRODUCT_ATTRIBUTE
PRODUCT_ATTR_VALUE
QP_QUALIFIERS
QUALIFIER_ID
LIST_HEADER_ID
LIST_LINE_ID
QUALIFIER_CONTEXT
QUALIFIER_ATTRIBUTE
QUALIFIER_ATTR_VALUE
COMPARISON_OPERATOR_CODE
LIST_TYPE_CODE AGR, CHARGES, DTL, PRL, PRO, SLT
Price Lists:
QP_LIST_HEADERS_B
This table stores the header information for all lists. List types can be, for example, Price Lists, Discount.
LIST_HEADER_ID
CURRENCY_CODE
ROUNDING_FACTOR
LIST_TYPE_CODE Price list = PRL, Promotion = PRO
PARENT_LIST_HEADER_ID
ACTIVE_FLAG
QP_LIST_HEADERS_TL
This table stores the translatable columns, name and description of the list, in each of the available languages in the database.
LIST_HEADER_ID
NAME
DESCRIPTION
QP_LIST_LINES
This table stores all list lines for lists in QP_LIST_HEADERS_B.
LIST_LINE_ID
LIST_HEADER_ID
LIST_LINE_TYPE_CODE
LIST_PRICE
LIST_PRICE_UOM_CODE
INVENTORY_ITEM_ID
ORGANIZATION_ID
Customers:
HZ_CUST_ACCOUNTS, HZ_PARTIES (RA_CUSTOMERS)
Addresses
HZ_CUST_ACCT_SITES_ALL, HZ_PARTY_SITES, HZ_LOCATIONS (RA_ADDRESSES_ALL)
Sites
HZ_CUST_SITE_USES_ALL (RA_SITE_USES_ALL)
Interfaces (Import Orders):
The Sales Order has been modeled as a business object that Oracle Order Management owns. The Sales Order business object comprises of several entities, namely, Header, Header Sales Credits, Header Price Adjustments, Header Pricing Attributes, Header Adjustment Attributes, Header Adjustment Associations, Lines, Line Sales Credits, Line Price Adjustments, Line Pricing Attributes, Line Adjustment Attributes, Line Adjustment Associations and Line Lot Serial Numbers.
Order Import can import new, change, and completed sales orders or returns from other applications such as a legacy system. The orders may come from any source such as EDI transactions that are processed by the Oracle e-Commerce Gateway or internal orders created for internal requisitions developed in Oracle Purchasing or returns.
Order Import features include validation and defaulting, processing constraint checks, applying and releasing of order holds, scheduling of shipments, then ultimately inserting, updating or deleting the orders in the base Order Management tables. Order Management checks all the data during the import process to ensure its validity within Order Management. Valid transactions are then converted into orders with lines, reservations, price adjustments, and sales credits in the base Order Management tables.
You can setup your defaulting rules which allow you to default columns in the same way as for orders entered online. You can pass the column value Null to Order Import if you want the defaulting rules to populate the column. However, if the column is defined as Not Null or Mandatory column and the defaulting rules fail to default the column, for any reason, Order Import displays an error message without importing the order.
Import Types:
Configurations
Order Management provides you with the ability to import ATO and PTO configurations.
Changes
You can import changes to orders that have been imported by passing all changed data through Order Import. You can update or delete orders, order lines, price adjustments, and sales credits. You can use change sequence numbers to control the sequence of changes you want to make to orders.
Order Status
You can import new, booked or closed orders. If an order is imported with an entry status of Booked (OE_HEADERS_IFACE_ALL.BOOKED_FLAG=Y) the result after import is that a Action Request of BOOK_ORDER is initiated. You may also pass the Action Request to BOOK_ORDER; both methods are supported.
Workflows
You can import an order within any valid order workflow activity. The order must be at the initial activity of Entered, Booked, or Closed. Orders imported using Order Import cannot be in the middle of a workflow activity.
Manual and Automatic Pricing
Pricing in process order API can be controlled using flag calculate_price_flag on order line record. When set to ‘Y ‘the process order API fetches the list price and applies adjustments and charges. When set to N, the process order API would fetch a list price if the list price is not passed and no adjustments would be applied. When set to P, all the modifiers which are associated with phases having override freeze flag set to Y are applied. That mainly includes freight charges.
Scheduling
Order Import allows you to reserve orders as they are imported, using the same rules as online order entry. If the scheduling request is unsuccessful on an imported order, the order will still be imported, and the scheduling exceptions can be viewed in the Error Messages of the Order Import Corrections window. You can use Schedule, Unschedule, Reserve or Unreserve as values for scheduling actions.
Return Lines
Process order can be used to create and update return lines also. To create a return line, you can either pass in the line category of RETURN on the order line record and the line type would default to the inbound line type of the order type. Alternatively, you can also provide a line type of the type Return on the order line record. Additionally, if you want to specify a reference for the return line, you can pass in the return flexfields (return_context, return_attribute1-2). Column Return_Context can have the following values to determine the reference
type:
Sales Order
Customer PO
Invoice
Serial Number
Process Order Application Open Interface Return_Attribute1... Return_Attribute2 can have the following values depending on the reference type:
1. Sales Order
return_Attribute1: Header ID
return_Attribute2: Line ID
2. Customer PO
return_Attribute1: Header ID
return_Attribute2: Line ID
3. Invoice
return_Attribute1: Invoice Header ID
return_Attribute2: Invoice Line ID
4. Serial Number
return_Attribute1: Inventory Item ID
return_Attribute2: Serial Number
If you wish to import an order as booked, you must set the OPERATION_CODE column
in the actions interface table OE_ACTIONS_IFACE_ALL with a value of "BOOK_ORDER".
Do not use the BOOKED_FLAG column in the OE_HEADERS_IFACE_ALL table. This will
cause the order header to show as booked, but not the order lines. The order
lines will not progress through workflow to the Pick Release/Shipping actions.
OE_CUSTOMER_INFO_IFACE_ALL
OE_HEADERS_IFACE_ALL
Column Name
|
Required
(C = Conditionally
Required)
|
Conditionally
Required for
Booking
|
ORIG_SYS_DOCUMENT_REF
|
REQUIRED
| |
SALESREP_ID or
SALESREP
|
REQUIRED
| |
INVOICING_RULE_ID or
INVOICING_RULE
|
REQUIRED
| |
ACCOUNTING_RULE_ID or
ACCOUNTING_RULE
|
REQUIRED
| |
PAYMENT_TERM_ID or
PAYMENT_TERM
|
REQUIRED for Order Lines not Return lines
| |
AGREEMENT_ID
|
REQURIED if order type requires
| |
CREATED_BY
|
REQUIRED
| |
CREATION_DATE
|
REQUIRED
| |
LAST_UPDATED_BY
|
REQUIRED
| |
LAST_UPDATE_DATE
|
REQUIRED
| |
OPERATION_CODE
|
REQUIRED
| |
ORDER_SOURCE_ID or
ORDER_SOURCE
|
REQUIRED
| |
ORDER_TYPE_ID or
ORDER_TYPE
|
REQUIRED
| |
PRICE_LIST_ID or
PRICE_LIST
|
REQUIRED
| |
CONVERSION_RATE
CONVERSION_RATE_DATE
|
REQUIRED if conversion Type is User
| |
CONVERSION_TYPE_CODE
CONVERSION_TYPE
|
REQUIRED if order Currency is not same as SOB Currency
| |
CUTOMER_PO_NUMBER
|
REQUIRED if Order Type Requires
| |
TAX_EXEMPT_REASON_CODE
TAX_EXEMPT_REASON
|
REQUIRED if Tax Exempt flag is Exempt
| |
RETURN_REASON_CODE
|
Required for returns only
| |
SOLD_FROM_ORG_ID
SOLD_FROM_ORG
|
REQUIRED for Return Lines
| |
SOLD_TO_ORG_ID
SOLD_TO_ORG
CUSTOMER_NAME
|
REQUIRED for Order Lines not Return Lines
| |
SHIP_TO_ADDRESS1..4
SHIP_TO_CITY
SHIP_TO_COUNTY
SHIP_TO_CUSTOMER
SHIP_TO_CUSTOMER_NUMBER
SHIP_TO_POSTAL_CODE
SHIP_TO_PROVINCE
SHIP_TO_SITE_INT
SHIP_TO_STATE
SHIP_TO_COUNTRY
|
These columns orShip_to_Org_idshould be provided
| |
INVOICE_ADDRESS1..4
INVOICE _TO_CITY
INVOICE _TO_COUNTY
INVOICE _TO_CUSTOMER
INVOICE _TO_CUSTOMER_NUMBER
INVOICE _TO_POSTAL_CODE
INVOICE _TO_PROVINCE
INVOICE _TO_SITE_INT
INVOICE _TO_STATE
INVOICE _TO_COUNTRY
|
These columns orInvoice_To_Org_idshould be
|
OE_LINES_IFACE_ALL
Column Name
|
Required
(C = Conditionally
Required)
|
Conditionally
Required for
Booking
|
ORDER_SOURCE_ID
|
REQUIRED
| |
ORIG_SYS_DOCUMENT_REF
|
REQUIRED
| |
ORIG_SYS_LINE_REF
|
REQUIRED
| |
ORIG_SYS_SHIPMENT_REF
|
REQUIRED
| |
INVENTORY_ITEM_ID or
INVENTORY_ITEM
|
REQUIRED
| |
TOP_MODEL_LINE_REF
|
Required for model items only
| |
LINK_TO_LINE_REF
|
Required for model items only
| |
REQUEST_DATE
|
REQUIRED
| |
DELIVERY_LEAD_TIME
|
REQUIRED
| |
DELIVERY_ID
|
REQUIRED
| |
ORDERED_QUANTITY
|
REQUIRED
| |
ORDER_QUANTITY_UOM
|
REQUIRED
| |
SHIPPING_QUANTITY
|
REQUIRED
| |
SHIPPING_QUANTITY_
UOM
|
REQUIRED
| |
PRICING_QUANTITY
|
REQUIRED
| |
PRICING_QUANTITY_
UOM
|
REQUIRED
| |
SOLD_FROM_ORG_ID
SOLD_FROM_ORG
|
REQUIRED for Retunr Lines only
| |
SOLD_TO_ORG_ID
SOLD_TO_ORG
|
REQUIRED for Order lines
| |
SHIP_TO_ADDRESS1..4
SHIP_TO_CITY
SHIP_TO_COUNTY
SHIP_TO_CUSTOMER
SHIP_TO_CUSTOMER_NUMBER
SHIP_TO_POSTAL_CODE
SHIP_TO_PROVINCE
SHIP_TO_SITE_INT
SHIP_TO_STATE
SHIP_TO_COUNTRY
|
These columns orShip_to_Org_idshould be provided
| |
INVOICE_ADDRESS1..4
INVOICE _TO_CITY
INVOICE _TO_COUNTY
INVOICE _TO_CUSTOMER
INVOICE _TO_CUSTOMER_NUMBER
INVOICE _TO_POSTAL_CODE
INVOICE _TO_PROVINCE
INVOICE _TO_SITE_INT
INVOICE _TO_STATE
INVOICE _TO_COUNTRY
|
These columns orInvoice_To_Org_idshould be
| |
PRICE_LIST_ID or
PRICE_LIST
|
REQUIRED
| |
INVOICING_RULE_ID or
INVOICING_RULE
|
REQUIRED
| |
ACCOUNTING_RULE_ID or
ACCOUNTING_RULE
|
REQUIRED
| |
PAYMENT_TERM_ID or
PAYMENT_TERM
|
REQUIRED for Order lines not for Return Lines
| |
RETURN_REASON_CODE
|
Required for returns only
| |
REFERENCE_TYPE
|
REQUIRED
| |
REFERENCE_HEADER_ID or
REFERENCE_HEADER
|
REQUIRED
| |
REFERENCE_LINE_ID or
REFERENCE_LINE
|
REQUIRED
| |
SERVICE_DURATION
|
Should be populated only for service items
| |
SERVICE_START_DATE
|
Should be populated only for service items
| |
SERVICE_END_DATE
|
Should be populated only for service items
| |
SERVICE_COTERMINATE_
FLAG
|
Should be populated only for service items
| |
REQUEST_ID
|
REQUIRED
| |
CREATED_BY
|
REQUIRED
| |
CREATION_DATE
|
REQUIRED
| |
LAST_UPDATED_BY
|
REQUIRED
| |
LAST_UPDATE_DATE
|
REQUIRED
|
OE_PRICE_ADJS_IFACE_ALL
CREATED_BY
|
REQUIRED
| |
CREATION_DATE
|
REQUIRED
| |
LAST_UPDATED_BY
|
REQUIRED
| |
LAST_UPDATE_DATE
|
REQUIRED
| |
OPERATION_CODE
|
REQUIRED
| |
ORIG_SYS_DOCUMENT_REF
|
REQUIRED
| |
ORIG_SYS_LINE_REF
|
REQUIRED
| |
ORIG_SYS_SHIPMENT_REF
|
REQUIRED
| |
PRICE_ADJUSTMENT_ID
|
REQUIRED for Update and Delete
| |
LIST_HEADER_ID
|
Only for Tax Records
| |
LIST_LINE_ID
|
Only for Tax Records
|
OE_PRICE_ATTRS_IFACE_ALL
CREATED_BY
|
REQUIRED
| |
CREATION_DATE
|
REQUIRED
| |
LAST_UPDATED_BY
|
REQUIRED
| |
LAST_UPDATE_DATE
|
REQUIRED
| |
OPERATION_CODE
|
REQUIRED
| |
ORIG_SYS_DOCUMENT_REF
|
REQUIRED
| |
ORIG_SYS_LINE_REF
|
REQUIRED
| |
ORIG_SYS_SHIPMENT_REF
|
REQUIRED
|
OE_CREDITS_IFACE_ALL
PERCENT
|
REQUIRED
| |
SALES_CREDIT_TYPE_IDor
SALES_CREDIT_TYPE
|
REQUIRED
| |
OPERATION_CODE
|
REQUIRED
| |
ORIG_SYS_DOCUMENT_REF
|
REQUIRED
| |
ORIG_SYS_LINE_REF
|
REQUIRED
| |
ORIG_SYS_SHIPMENT_REF
|
REQUIRED
| |
ORIG_SYS_CREDIT_REF
|
REQUIRED
|
OE_LOTSERIALS_IFACE_ALL
ORDER_SOURCE_ID
|
REQUIRED
| |
ORIG_SYS_DOCUMENT_REF
|
REQUIRED
| |
ORIG_SYS_LINE_REF
|
REQUIRED
| |
ORIG_SYS_SHIPMENT_REF
|
REQUIRED
| |
ORIG_SYS_LOTSERIAL_
REF
|
REQUIRED
| |
LOT_NUMBER
|
C
| |
FROM_SERIAL_NUMBER
|
C
| |
TO_SERIAL_NUMBER
|
C
| |
QUANTITY
|
REQUIRED
| |
CREATED_BY
|
REQUIRED
| |
CREATION_DATE
|
REQUIRED
| |
LAST_UPDATED_BY
|
REQUIRED
| |
LAST_UPDATE_DATE
|
REQUIRED
| |
LAST_UPDATE_LOGIN
|
REQUIRED
| |
OPERATION_CODE
|
REQUIRED
|
OE_RESERVTNS_IFACE_ALL
ORDER_SOURCE_ID
|
REQUIRED
| |
ORIG_SYS_DOCUMENT_REF
|
REQUIRED
| |
ORIG_SYS_LINE_REF
|
REQUIRED
| |
ORIG_SYS_SHIPMENT_REF
|
REQUIRED
| |
ORIG_SYS_RESERVATION_REF
|
REQUIRED
| |
INVENTORY_ITEM_ID
|
REQUIRED
| |
SUBINVENTORY_ID
|
REQUIRED
| |
QUANTITY
|
REQUIRED
| |
OPERATION_CODE
|
REQUIRED
|
OE_ACTIONS_IFACE_ALL
ORIG_SYS_DOCUMENT_REF
|
REQUIRED
| |
OPERATION_CODE
|
REQUIRED
|
Setups
Transaction Types
OE_TRANSACTION_TYPES_ALL
OE_TRANSACTION_TYPES_TL
This is a mult-lingual table for OE_TRANSACTION_TYPES_ALL table
SELECTOH.ORDER_NUMBER,OTTA.ORDER_CATEGORY_CODE,OTTA.ORG_ID,OTTL.NAME
FROM OE_ORDER_HEADERS_ALL OH
,OE_TRANSACTION_TYPES_ALL OTTA
,OE_TRANSACTION_TYPES_TL OTTL
WHERE OH.ORDER_TYPE_ID = OTTA.TRANSACTION_TYPE_ID
AND OTTA.TRANSACTION_TYPE_ID = OTTL.TRANSACTION_TYPE_ID
AND order_number = 1130100008;
OE_WORKFLOW_ASSIGNMENTS
This table associates assignments to order types and line types.
ORDER_TYPE_ID
LINE_TYPE_ID
PROCESS_NAME
ASSIGNMENT_ID
Document Sequence
For Document Sequence record stores in FND_DOCUMENT_SEQUENCES. After creating the Transaction Type, automatically the Document Category gets created and record goes to table FND_DOCUMENT_CATEGORIES.
FND_DOCUMENT_SEQUENCES
DOCUMENT_SEQUENCE_ID
NAME
INITIAL_VALUE
TABLE_NAME OE_TRANSACTION_TYPES_ALL
FND_DOCUMENT_CATEGORIES
APPLICATION_ID
CODE
NAME TRANSACTION TYPE NAME
DESCRIPTION
TABLE_NAME OE_TRANSACTION_TYPES_ALL
FND_DOCUMENT_CATEGORIES
DOC_SEQUENCE_ASSIGNMENT_ID
APPLICATION_ID
DOCUMENT_SEQUENCE_ID
CATEGORY_ID
SET_OF_BOOKS_ID
Order Import Sources
OE_ORDER_SOURCES
ORDER_SOURCE_ID
NAME
DESCRIPTION
ENABLED_FLAG
Payment terms
RA_TERMS
TERM_ID
NAME
DESCRIPTION
BASE_AMOUNT
RA_TERMS_LINES
TERM_ID
SEQUENCE_NUM
RELATIVE_AMOUNT
DUE_DAYS
Holds
OE_ORDER_HOLDS_ALL
This table stores information of all the orders and lines that are on hold and the link to hold sources and hold releases.
HOLD_SOURCE_ID
HEADER_ID
LINE_ID
ORG_ID
RELEASED_FLAG
OE_HOLD_AUTHORIZATIONS
Stores information about who has the authority to apply and release holds.– Retrofitted
OE_HOLD_DEFINITIONS
This table stores information about hold name and its validity period.
OE_HOLD_RELEASES
This tables stores information about all the holds that has been released.
Lookups
FND_LOOKUP_VALUES Quick Code values
LOOKUP_TYPE
LOOKUP_CODE
MEANING
DESCRIPTION
Sales Person
JTF_RS_SALESREPS (RA_SALESREPS_ALL)
Territories
RA_TERRITORIES
TERRITORY_ID
NAME
DESCRIPTION
SEGMENT1
SEGMENT2
.
.
.
SEGEMNT20
REGION_ID
Sales Credit Types
SELECT CR.SALES_CREDIT_ID
,SREP.NAME
,CR_TYPE.NAME
,CR.PERCENT
FROM OE_SALES_CREDITS CR
,JTF_RS_SALESREPS SREP
,OE_ORDER_HEADERS_ALL OH
,OE_SALES_CREDIT_TYPES CR_TYPE
WHERE CR.SALESREP_ID = SREP.SALESREP_ID
AND CR.HEADER_ID = OH.HEADER_ID
AND OH.ORG_ID = SREP.ORG_ID
AND CR_TYPE.SALES_CREDIT_TYPE_ID = CR.SALES_CREDIT_TYPE_ID
AND OH.ORDER_NUMBER = 1130100005;
Profiles
Credit Check Rules
OE_CREDIT_CHECK_RULES This table stores information about the credit check rules.
PO_DISTRIBUTIONS_ALL Purchase order distributions
PO_HEADERS_ALL Document headers (for purchase orders, purchase agreements, quotations, RFQs)
PO_INTERFACE_ERRORS Requisition import interface errors
PO_LINES_ALL Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINE_LOCATIONS_ALL Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)
PO_REQUISITIONS_INTERFACE_ALL Requisition Import interface table
PO_REQUISITION_HEADERS_ALL Requisition headers
PO_REQUISITION_LINES_ALL Requisition lines
PO_REQ_DISTRIBUTIONS_ALL Requisition distributions
Pricing
QP_ATTRIBUTE_DEFNS QP_ATTRIBUTE_DEFNS is the table on which the Qualifier
and Pricing Attribute Descriptive Flexfields are based. It is used for the entity and attribute definiton in attribute sourcing.
QP_COUPONS QP_COUPONS stores any Coupons which have been issued.
QP_EVENT_PHASES QP_EVENT_PHASES stores the mapping between pricing events and pricing phases.
QP_LIST_HEADERS_B QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount
QP_LIST_HEADERS_TL QP_LIST_HEADERS_TL stores the translatable columns, name and description of the list, in each of the available languages in the database.
QP_LIST_LINES QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. QP_PRICE_FORMULAS_B QP_PRICE_FORMULAS_B stores the pricing formula header information.
QP_PRICE_FORMULAS_TL This table stores the translatable columns, name & description of the pricing formulas, in each of the available languages in the database.
QP_PRICE_FORMULA_LINES QP_PRICE_FORMULA_LINES stores each component that makes up the formula.
QP_PRICE_REQ_SOURCES QP_PRICE_REQ_SOURCES stores the mapping between Pricing Request Types and Source Systems.
QP_PRICING_ATTRIBUTES QP_PRICING_ATTRIBUTES stores product information and pricing attributes.
QP_PRICING_PHASES QP_PRICING_PHASES stores all pricing phases.
QP_QUALIFIERS QP_QUALIFIERS stores qualifier attribute information.
QP_QUALIFIER_RULES QP_QUALIFIER_RULES stores the header information for all qualifier rules
QP_RLTD_MODIFIERS QP_RLTD_MODIFIERS stores the relationship between modifier lines. QP_UPGRADE_ERRORS QP_UPGRADE_ERRORS holds details of the errors which occured in upgrading pricing data.
No comments:
Post a Comment