Send Sales Order Service

This service is in the WmOAOMG1227 package and has the following fully-qualified service name: orderManagement1227.fromOA.salesOrder:sendSalesOrder.

This service notifies and delivers sales order changes. This service selects Booked Order Records only.

Database Scripts

This service uses the following database scripts:

Database Script	Description
wm_install_from_salesorder.sql	Runs all the scripts listed below, except the uninstall script.
wm_from_salesorder_vw.sql	Creates required views for Sales Order outbound transactions: WM_ORDER_HEADERS_VW WM_ORDER_LINES_VW WM_SALES_CREDITS_VW WM_HEADER_SALES_CREDIT_VW WM_PRICE_ADJ_VW WM_HEADER_PRICE_ADJ_VW WM_PRICE_ATTRIBS_VW WM_HEADER_PRICE_ATTRB_VW WM_OE_RESERVTNS_VW WM_LOTSERIALS_VW WM_OE_ACTIONS_VW WM_OE_LINE_ACTIONS_VW WM_ORDER_HEADER_QRY_VW
wm_from_salesorder_trg.sql	Creates the following trigger components to be used for writing to the WM_TRACKCHANGES table to indicate a new or updated document: WM_ORDER_HEADERS_IU_TRG WM_ORDER_LINES_IUD_TRG WM_SALES_CREDITS_IUD_TRG WM_OE_LOTSERIAL_IUD_TRG WM_OE_PRICE_ADJ_IUD_TRG WM_OE_PRICE_ATTRIBS_IUD_TRG WM_LINE_SETS_IUD_TRG
wm_drop_from_salesorder.sql	Uninstalls all components created by wm_install_from_salesorder.sql.

For more information about using database scripts, see Database Scripts.

Supporting Transaction Definitions

This service was built from the configured services defined in the following transaction definition:

getSalesOrderTxn1227.txp

For information about using the transaction definition files to customize this service, see Transaction Definitions.

Flow Control

The main flow executes as follows:

specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
lockTxnCtrl determines whether the Send Sales Order service is ready for execution. That is, it determines whether there is no other instance of this service already in process.
- If the lockTxnCtrl service returns False, another instance of this service is already in process. The service exits, and waits for next scheduled execution.
- If the lockTxnCtrl service returns True, the service is ready to execute. The SalesOrder row in the control table is locked and updated so that the status is changed to INPROCESS, which prevents other SalesOrder services from executing.
The getSalesOrderTxn service queries the Oracle Applications database for any SalesOrder Transaction to be processed. The number of records returned depends on the parameter value specified in the above map.
processBizDoc is the customizable step which sends the business document to the trading partner by looping against each document. You must customize this step to receive a SUCCESS or an ERROR status of the document transfer along with the error information. The transfer status and any error information are logged against each document.
Loop against each document. Based on the Debug Mode specified during execution, it either purges or updates the records in the WM_TRACKCHANGES custom table.
- If the Debug Mode is TRUE, the records in the WM_TRACKCHANGES table are updated and the PROCESSED_FLAG is set to Y. This ensures that same sets of records are not picked up during next polling interval. The updateTrackChanges service updates the PROCESSED_FLAG in the WM_TRACKCHANGES table to Y and PROCESSED_DATE to sysdate so that same information is not picked up again during next polling instance.
- If the Debug Mode is FALSE, the records in the WM_TRACKCHANGES table are deleted. The purgeTrackChanges service purges the records from the WM_TRACKCHANGES table.
Loop against each document. Based on the Transfer Status, insertTransferERRInfo service inserts a new record in the WM_TRACKCHANGES table so that same document can be picked up during the next polling interval.
The unlockTxnCtrl service releases the lock on the Custom Control table so that next polling instance of Send Vendor service can begin.
getLastError logs any errors that occur in the above steps.
The unlockTxnCtrl service releases the lock on the Custom Control table.

For more details on send transactions, see Overview of Send Service Transaction Processing.

Business Document Structure

This business document structure is as follows:

1.0 ORDER_HEADERS
- 1.1 ORDER_LINES
  - 1.1.1 PRICE_ADJ
  - 1.1.2 PRICE_ATTRIBS
  - 1.1.3 LOTSERIALS
  - 1.1.4 SALES_CREDITS
  - 1.1.5 OE_RESERVTNS
  - 1.1.6 OE_LINE_ACTIONS
- 1.2 HEADER_PRICE_ATTRIB
- 1.3 HEADER_PRICE_HEADER_PRICE_ADJ
- 1.4 HEADER_SALES_CREDIT
- 1.5 OE_ACTIONS

Documents using the same tables

For These Documents...	Use the following table:
1.2 HEADER_PRICE_ATTRIB	1.1.2 PRICE_ATTRIBS (Except LINE_ID as it represents the order’s price attributes).
1.3 HEADER_PRICE_ADJ	1.1.1 PRICE_ADJ (Except LINE_ID as it represents the order’s price adjustments).
1.4 HEADER_SALES_CREDIT	1.1.4 SALES_CREDITS (Except LINE_ID as it represents the order’s price credits).
1.5 OE_ACTIONS	1.1.6 OE_LINE_ACTIONS (Except LINE_ID as it represents the order actions).

1.0 ORDER_HEADERS

Field Name	Oracle Applications Table/View Name	Column Name	Description
WEB_ TRANSACTION_ID
DOCUMENT_TYPE			Use ORDER.
DOCUMENT_STATUS			Valid values are INSERT. UPDATE. DELETE.
HEADER_ID	OE_ORDER_ HEADERS_ALL	HEADER_ID
FLOW_STATUS_ CODE	OE_ORDER_ HEADERS_ALL	FLOW_STATUS_ CODE	Order flow status code.
ORDER_TYPE	OE_ TRANSACTION_ TYPES_TL	NAME
ORGANIZATION_ NAME	HR_ALL_ ORGANIZATION_ UNITS	NAME
ORDER_NUMBER	OE_ORDER_ HEADERS_ALL	ORDER_ NUMBER	Unique number assigned to the order.
VERSION_NUMBER	OE_ORDER_ HEADERS_ALL	VERSION_ NUMBER	Order version number.
ORDERED_DATE	OE_ORDER_ HEADERS_ALL	ORDERED_DATE	Date of the order.
ORDER_CATEGORY	OE_LOOKUPS	MEANING
ORDER_SOURCE	OE_ORDER_ SOURCES	NAME
PRICE_LIST	QP_LIST_ HEADERS_TL	NAME
ORIG_SYS_ DOCUMENT_REF	OE_ORDER_ HEADERS_ALL	ORIG_SYS_ DOCUMENT_ REF	Original document reference for the order in the external system.
CONVERSION_ RATE	OE_ORDER_ HEADERS_ALL	CONVERSION_ RATE
CONVERSION_ RATE_DATE	OE_ORDER_ HEADERS_ALL	CONVERSION_ RATE_DATE
CONVERSION_ TYPE_CODE	OE_ORDER_ HEADERS_ALL	CONVERSION_ TYPE_CODE
CONVERSION_TYPE	GL_DAILY_ CONVERSION_ TYPES	USER_ CONVERSION_ TYPE
TRANSACTIONAL_ CURR_CODE	OE_ORDER_ HEADERS_ALL	TRANSACTIONAL_ CURR_CODE	Currency Code.
SALESREP	RA_SALESREPS_ALL	NAME	Sales representative’s name.
SALES_CHANNEL_ CODE	OE_ORDER_ HEADERS_ALL	SALES_ CHANNEL_ CODE	Sales channel through which order was placed.
SALES_CHANNEL	OE_LOOKUPS	MEANING
RETURN_REASON_ CODE	OE_ORDER_ HEADERS_ALL	RETURN_ REASON_ CODE
RETURN_REASON	FND_LOOKUP_ VALUES	MEANING
TAX_POINT_CODE	OE_ORDER_ HEADERS_ALL	TAX_POINT_CODE
TAX_POINT	OE_LOOKUPS	MEANING	Tax point description
TAX_EXEMPT_FLAG	OE_ORDER_ HEADERS_ALL	TAX_EXEMPT_FLAG	Use: S for Standard E for Exempt R for Required
TAX_EXEMPT_ NUMBER	OE_ORDER_ HEADERS_ALL	TAX_EXEMPT_ NUMBER	Tax exemption number.
TAX_EXEMPT_ REASON_CODE	OE_ORDER_ HEADERS_ALL	TAX_EXEMPT_ REASON_CODE	Tax exemption reason code.
TAX_EXEMPT_ REASON	AR_LOOKUPS	MEANING	Tax exemption reason.
AGREEMENT	OE_ AGREEMENTS_ TL	NAME
INVOICING_RULE	RA_RULES	NAME
ACCOUNTING_RULE	RA_RULES	NAME
PAYMENT_TERM	RA_TERMS_TL	NAME
DEMAND_CLASS_CODE	OE_ORDER_ HEADERS_ALL	DEMAND_ CLASS_CODE
DEMAND_CLASS	OE_FND_ COMMON_ LOOKUPS_V	MEANING
SHIPMENT_ PRIORITY_CODE	OE_ORDER_ HEADERS_ALL	SHIPMENT_ PRIORITY_ CODE
SHIPMENT_ PRIORITY	OE_LOOKUPS	MEANING
SHIPMENT_ PRIORITY_CODE_ INT	OE_ORDER_ HEADERS_ALL	SHIPMENT_ PRIORITY_ CODE
SHIPPING_ METHOD_CODE	OE_ORDER_ HEADERS_ALL	SHIPPING_ METHOD_ CODE
SHIPPING_METHOD	OE_SHIP_METHODS_V	MEANING
FREIGHT_ CARRIER_CODE	OE_ORDER_ HEADERS_ALL	FREIGHT_ CARRIER_ CODE
FREIGHT_CARRIER	ORG_FREIGHT	DESCRIPTION
FREIGHT_ TERMS_CODE	OE_ORDER_ HEADERS_ALL	FREIGHT_ TERMS_ CODE
FREIGHT_TERMS	OE_LOOKUPS	MEANING
FOB_POINT_CODE	OE_ORDER_ HEADERS_ALL	FOB_POINT_CODE	Free on Board point code.
FOB_POINT	AR_LOOKUPS	MEANING
PARTIAL_ SHIPMENTS_ ALLOWED	OE_ORDER_ HEADERS_ALL	PARTIAL_ SHIPMENTS_ ALLOWED
SHIP_ TOLERANCE_ ABOVE	OE_ORDER_ HEADERS_ALL	SHIP_ TOLERANCE_ ABOVE	Over shipment or return tolerance.
SHIP_ TOLERANCE_ BELOW	OE_ORDER_ HEADERS_ALL	SHIP_ TOLERANCE_ BELOW	Under shipment or return Tolerance.
SHIPPING_ INSTRUCTIONS	OE_ORDER_ HEADERS_ALL	SHIPPING_ INSTRUCTIONS
PACKING_ INSTRUCTIONS	OE_ORDER_ HEADERS_ALL	PACKING_ INSTRUCTIONS
ORDER_DATE_ TYPE_CODE	OE_ORDER_ HEADERS_ALL	ORDER_ DATE_ TYPE_CODE
EARLIEST_ SCHEDULE_LIMIT	OE_ORDER_ HEADERS_ALL	EARLIEST_ SCHEDULE_ LIMIT	Number of days earlier than the requested date to ship item.
LATEST_ SCHEDULE_LIMIT	OE_ORDER_ HEADERS_ALL	LATEST_ SCHEDULE_ LIMIT	Number of days later than the requested date to ship item.
CUST_PO_ NUMBER	OE_ORDER_ HEADERS_ALL	CUST_PO_ NUMBER
PAYMENT_ TYPE_CODE	OE_ORDER_ HEADERS_ALL	PAYMENT_ TYPE_CODE	Type of payment for orders such as cash, check, or credit.
PAYMENT_ AMOUNT	OE_ORDER_ HEADERS_ALL	PAYMENT_ AMOUNT	Amount of payment.
CHECK_NUMBER	OE_ORDER_ HEADERS_ALL	CHECK_ NUMBER	Check number if paid by check.
CREDIT_CARD_ CODE	OE_ORDER_ HEADERS_ALL	CREDIT_ CARD_CODE	Credit card name if paid by credit card.
CREDIT_CARD_ HOLDER_NAME	OE_ORDER_ HEADERS_ALL	CREDIT_CARD_ HOLDER_NAME	Credit card holder name if paid by credit card.
CREDIT_CARD_ NUMBER	OE_ORDER_ HEADERS_ALL	CREDIT_CARD_ NUMBER	Credit card number if paid by credit card.
CREDIT_CARD_ EXPIRATION_DATE	OE_ORDER_ HEADERS_ALL	CREDIT_CARD_ EXPIRATION_ DATE	Credit card expiration date if paid by credit card.
CREDIT_CARD_ APPROVAL_CODE	OE_ORDER_ HEADERS_ALL	CREDIT_CARD_ APPROVAL_ CODE	Credit card approval code if paid by credit card.
SOLD_FROM_ORG	HR_ALL_ ORGANIZATION_ UNITS	NAME
SOLD_TO_ORG	HZ_PARTIES	PARTY_NAME
SHIP_FROM_ORG	HR_ALL_ ORGANIZATION_ UNITS	NAME
SHIP_TO_ORG	HZ_CUST_ SITE_USES_ALL	LOCATION
SHIP_TO_ADDRESS1	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS1
SHIP_TO_ADDRESS2	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS2
SHIP_TO_ADDRESS3	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS3
SHIP_TO_ADDRESS4	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS4
SHIP_TO_CITY	HZ_CUST_ ACCT_SITES_ ALL	CITY
SHIP_TO_COUNTY	HZ_CUST_ ACCT_SITES_ ALL	COUNTY
SHIP_TO_STATE	HZ_CUST_ ACCT_SITES_ ALL	STATE
SHIP_TO_POSTAL_ CODE	HZ_CUST_ ACCT_SITES_ ALL	POSTAL_CODE
SHIP_TO_PROVINCE	HZ_CUST_ ACCT_SITES_ ALL	PROVINCE
SHIP_TO_COUNTRY	HZ_CUST_ ACCT_SITES_ ALL	COUNTRY
SHIP_TO_ CUSTOMER_NUMBER	HZ_CUST_ ACCOUNTS	ACCOUNT_ NUMBER	Ship To sales order number.
SHIP_TO_CUSTOMER	HZ_PARTIES	PARTY_NAME	Ship To sales order name.
INVOICE_TO_ORG	HZ_CUST_SITE_ USES_ALL	LOCATION	Invoice To organization.
INVOICE_ADDRESS1	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS1	Invoice To address line 1.
INVOICE_ADDRESS2	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS2	Invoice To address line 2.
INVOICE_ADDRESS3	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS3	Invoice To address line 3.
INVOICE_ADDRESS4	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS4	Invoice To address line 4.
INVOICE_CITY	HZ_CUST_ ACCT_SITES_ ALL	CITY	Invoice To city.
INVOICE_COUNTY	HZ_CUST_ ACCT_SITES_ ALL	COUNTY	Invoice To county.
INVOICE_STATE	HZ_CUST_ ACCT_SITES_ ALL	STATE	Invoice To state.
INVOICE_POSTAL_ CODE	HZ_CUST_ ACCT_SITES_ ALL	POSTAL_CODE	Invoice To postal code.
INVOICE_ PROVINCE_INT	HZ_CUST_ ACCT_SITES_ ALL	PROVINCE	Invoice To province.
INVOICE_COUNTRY	HZ_CUST_ ACCT_SITES_ ALL	COUNTRY	Invoice To country.
INVOICE_CUSTOMER_ NUMBER	HZ_CUST_ ACCOUNTS	ACCOUNT_ NUMBER	Invoice’s sales order number.
INVOICE_CUSTOMER	HZ_PARTIES	PARTY_NAME	Invoice’s sales order name.
DELIVER_TO_ORG	HZ_CUST_ SITE_USES_ ALL	LOCATION	Deliver To organization.
DELIVER_TO_CONTACT	OE_CONTACTS_V	NAME	Deliver To contact.
DELIVER_TO_ CUSTOMER_ NUMBER	HZ_CUST_ ACCOUNTS	ACCOUNT_ NUMBER	Deliver To sales order number.
DELIVER_TO_ CUSTOMER	HZ_PARTIES	PARTY_NAME	Deliver To sales order name.
SOLD_TO_CONTACT	HZ_ORG_ CONTACTS	LAST_NAME \|\| FIRST_NAME \|\| TITLE
SHIP_TO_CONTACT_ FIRST_NAME	HZ_PARTIES	PERSON_ FIRST_NAME
SHIP_TO_CONTACT_ LAST_NAME	HZ_PARTIES	PERSON_ LAST_NAME
SHIP_TO_CONTACT	HZ_ORG_ CONTACTS	LAST_NAME \|\| FIRST_NAME\|\|TITLE
INVOICE_TO_CONTACT _FIRST_NAME	HZ_PARTIES	PERSON_ FIRST_NAME	Invoice to contact first name.
INVOICE_TO_CONTACT _LAST_NAME	HZ_PARTIES	PERSON_ LAST_NAME	Invoice to contact last name.
INVOICE_TO_CONTACT	HZ_ORG_ CONTACTS	PERSON_ LAST_NAME \|\| PERSON_ FIRST_NAME \|\| TITLE	Invoice to contact name.
CREDIT_CARD_ APPROVAL_DATE	OE_ORDER_ HEADERS_ALL	CREDIT_CARD_ APPROVAL_ DATE
BOOKED_FLAG	OE_ORDER_ HEADERS_ALL	BOOKED_FLAG	Indicates order was booked.
CANCELLED_FLAG	OE_ORDER_ HEADERS_ALL	CANCELLED_ FLAG	Indicate orders was cancelled.
CHANGE_SEQUENCE	OE_ORDER_ HEADERS_ALL	CHANGE_ SEQUENCE
CUSTOMER_NUMBER	HZ_CUST_ ACCOUNTS	ACCOUNT_ NUMBER	Number of the sales order.
CUSTOMER_NAME	HZ_PARTIES	PARTY_NAME	Name of the sales order.
CHANGE_REQUEST_CODE			Not used for outbound transactions.
ORDERED_BY_ CONTACT_PERSON_ FIRST_NAME			Not used for outbound transactions.
ORDERED_BY_ CONTACT_PERSON_ LAST_NAME			Not used for outbound transactions.
HEADER_PO_CONTEXT			Purchase order context.Not used for outbound transactions.
PO_REVISION_DATE			Purchase order revision date. Not used for outbound transactions.
CHANGE_REASON			Not used for outbound transactions.
CHANGE_COMMENT			Not used for outbound transactions.
OPERATION_CODE			Not used for outbound transactions.
CLOSED_FLAG			Not used for outbound transactions.
REJECTED_FLAG			Not used for outbound transactions.
READY_FLAG			Not used for outbound transactions.
STATUS_FLAG			Not used for outbound transactions.
FORCE_APPLY_FLAG			Not used for outbound transactions.

1.1 ORDER_LINES

Field Name	Oracle Applications Table/View Name	Column Name	Description
LINE_ID	OE_ORDER_ LINES_ALL	LINE_ID	Order line identifier.
HEADER_ID	OE_ORDER_ LINES_ALL	HEADER_ID	Order header identifier that is the same HEADER_ID as the one on the order
LINE_NUMBER	OE_ORDER_ LINES_ALL	LINE_NUMBER	Line sequence number within the order.
FLOW_STATUS_CODE	OE_ORDER_ LINES_ALL	FLOW_STATUS_ CODE	Order line status flow.
CHANGE_SEQUENCE			Not used for outbound transactions.
CHANGE_REQUEST_ CODE			Not used for outbound transactions.
ORDER_SOURCE	OE_ORDERSOURCES	NAME
ORIG_SYS_LINE_REF	OE_ORDER_ LINES_ALL	ORIG_SYS_ LINE_REF	Identifier of line from a source system outside Oracle Order Management.
ORIG_SYS_ SHIPMENT_REF	OE_ORDER_ LINES_ALL	ORIG_SYS_ SHIPMENT_REF	Original shipment information for the order line in the external system.
SHIPMENT_NUMBER	OE_ORDER_ LINES_ALL	SHIPMENT_ NUMBER	System-generated identifier of a shipment within a line.
SPLIT_LINE_LINE_REF	OE_ORDER_ LINES_ALL	ORIG_SYS_ LINE_REF	Split line identifier of line from a source system outside Oracle Order Management.
LINE_TYPE	OE_TRANSACTION_ TYPES_TL	NAME	Line transaction type.
ITEM_TYPE_CODE	OE_ORDER_ LINES_ALL	ITEM_ TYPE_CODE
ITEM_TYPE	OE_LOOKUPS	MEANING
SOURCE_TYPE_CODE	OE_ORDER_ LINES_ALL	SOURCE_ TYPE_CODE
SOURCE_TYPE	OE_LOOKUPS	MEANING
SCHEDULE_STATUS_ CODE	OE_ORDER_ LINES_ALL	SCHEDULE_ STATUS_CODE
SCHEDULE_STATUS	OE_LOOKUPS	MEANING
INVENTORY_ITEM	MTL_SYSTEM_ ITEMS_B_KFV	CONCATENATED_ SEGMENTS
TOP_MODEL_ LINE_REF	OE_ORDER_ LINES_ALL	ORIG_SYS_ LINE_REF	Top parent line.
LINK_TO_LINE_REF	OE_ORDER_ LINES_ALL	ORIG_SYS_ LINE_REF	Immediate parent component line.
ATO_LINE_REF	OE_ORDER_ LINES_ALL	ORIG_SYS_ LINE_REF	ATO configuration top model line.
EXPLOSION_DATE	OE_ORDER_ LINES_ALL	EXPLOSION_ DATE	Date when the included items were exploded and frozen.
COMPONENT_CODE	OE_ORDER_ LINES_ALL	COMPONENT_ CODE	Component within an exploded bill.
SORT_ORDER	OE_ORDER_ LINES_ALL	SORT_ORDER	Sorting sequence for a component in the ordered bill.
MODEL_GROUP_ NUMBER	OE_ORDER_ LINES_ALL	MODEL_GROUP_ NUMBER
OPTION_NUMBER	OE_ORDER_ LINES_ALL	OPTION_ NUMBER	Option or class in a model.
OPTION_FLAG	OE_ORDER_ LINES_ALL	OPTION_FLAG
SHIP_MODEL_ COMPLETE_FLAG	OE_ORDER_ LINES_ALL	SHIP_MODEL_ COMPLETE_ FLAG	Indicates the line is in ship–complete configuration.
SCHEDULE_ SHIP_DATE	OE_ORDER_ LINES_ALL	SCHEDULE_ SHIP_DATE	Date scheduled to ship item.
SCHEDULE_ ARRIVAL_DATE	OE_ORDER_ LINES_ALL	SCHEDULE_ ARRIVAL_DATE	Date scheduled for the item to arrive at the sales order site.
ACTUAL_ ARRIVAL_DATE	OE_ORDER_ LINES_ALL	ACTUAL_ ARRIVAL_DATE	Date the item actually arrived at sales order’s site
REQUEST_DATE	OE_ORDER_ LINES_ALL	REQUEST_DATE	Ordered item request date.
PROMISE_DATE	OE_ORDER_ LINES_ALL	PROMISE_DATE	Date promised to sales order to receive item.
DELIVERY_ LEAD_TIME	OE_ORDER_ LINES_ALL	DELIVERY_ LEAD_TIME
ORDERED_ QUANTITY	OE_ORDER_ LINES_ALL	ORDERED_ QUANTITY
ORDER_ QUANTITY_UOM	OE_ORDER_ LINES_ALL	ORDER_ QUANTITY_UOM	Ordered quantity unit of measurement.
SHIPPING_ QUANTITY	OE_ORDER_ LINES_ALL	SHIPPING_ QUANTITY
SHIPPING_ QUANTITY_UOM	OE_ORDER_ LINES_ALL	SHIPPING_ QUANTITY_UOM	Shipping quantity unit of measurement.
SHIPPED_ QUANTITY	OE_ORDER_ LINES_ALL	SHIPPED_ QUANTITY
CANCELLED_ QUANTITY	OE_ORDER_ LINES_ALL	CANCELLED_ QUANTITY
FULFILLED_ QUANTITY	OE_ORDER_ LINES_ALL	FULFILLED_ QUANTITY
PRICING_QUANTITY	OE_ORDER_ LINES_ALL	PRICING_QUANTITY
PRICING_ QUANTITY_UOM	OE_ORDER_ LINES_ALL	PRICING_ QUANTITY_UOM	Pricing quantity unit of measurement.
SOLD_FROM_ORG	HR_ALL_ ORGANIZATION_ UNITS	NAME
SOLD_TO_ORG	HZ_PARTIES	PARTY_NAME	Sales order to whom the item is sold.
SHIP_FROM_ORG	HR_ALL_ ORGANIZATION_ UNITS	NAME	Ship From organization
DELIVERY_NAME			Not used for outbound transactions.
SHIP_TO_ORG	HZ_CUST_SITE_ USES_ALL	LOCATION	Ship To organization.
SHIP_TO_ADDRESS1	HZ_LOCATIONS	ADDRESS1	Ship To address line 1.
SHIP_TO_ADDRESS2	HZ_LOCATIONS	ADDRESS2	Ship To address line 2.
SHIP_TO_ADDRESS3	HZ_LOCATIONS	ADDRESS3	Ship To address line 3.
SHIP_TO_ADDRESS4	HZ_LOCATIONS	ADDRESS4	Ship To address line 4.
SHIP_TO_CITY	HZ_LOCATIONS	CITY
SHIP_TO_COUNTY	HZ_LOCATIONS	COUNTY
SHIP_TO_STATE	HZ_LOCATIONS	STATE
SHIP_TO_ POSTAL_CODE	HZ_LOCATIONS	POSTAL_CODE
SHIP_TO_COUNTRY	HZ_LOCATIONS	COUNTRY
DELIVER_TO_ORG	HZ_CUST_SITE_ USES_ALL	LOCATION	Deliver To organization.
INVOICE_TO_ORG	HZ_CUST_SITE_ USES_ALL	LOCATION	Invoice To organization.
BILL_TO_ADDRESS1	HZ_LOCATIONS	ADDRESS1	Bill To address line 1.
BILL_TO_ADDRESS2	HZ_LOCATIONS	ADDRESS2	Bill To address line 2.
BILL_TO_ADDRESS3	HZ_LOCATIONS	ADDRESS3	Bill To address line 3.
BILL_TO_ADDRESS4	HZ_LOCATIONS	ADDRESS4	Bill To address line 4.
BILL_TO_CITY	HZ_LOCATIONS	CITY
BILL_TO_COUNTY	HZ_LOCATIONS	COUNTY
BILL_TO_STATE	HZ_LOCATIONS	STATE
BILL_TO_POSTAL_CODE	HZ_LOCATIONS	POSTAL_CODE
BILL_TO_COUNTRY	HZ_LOCATIONS	COUNTRY
SHIP_TO_CONTACT_ FIRST_NAME	HZ_PARTIES	PERSON_ FIRST_NAME
SHIP_TO_CONTACT_ LAST_NAME	HZ_PARTIES	PERSON_ LAST_NAME
SHIP_TO_CONTACT_ JOB_TITLE	HZ_ORG_ CONTACTS	JOB_TITLE
SHIP_TO_CONTACT	HZ_ORG_ CONTACTS	LAST_NAME\|\| FIRST_NAME\|\| TITLE
DELIVER_TO_CONTACT	OE_CONTACTS_V	NAME
INVOICE_TO_CONTACT	OE_CONTACTS_V	NAME
DROP_SHIP_FLAG			Not used for outbound transactions.
VEH_CUS_ITEM_ CUM_KEY	OE_ORDER_ LINES_ALL	VEH_CUS_ ITEM_CUM_ KEY_ID	Sales order item key.
CUST_PRODUCTION_ SEQ_NUM	OE_ORDER_ LINES_ALL	CUST_ PRODUCTION_ SEQ_NUM	Sales order production sequence number.
LOAD_SEQ_NUMBER			Load sequence number. Not used for outbound transactions.
OVER_SHIP_ REASON_CODE	OE_ORDER_ LINES_ALL	OVER_SHIP_ REASON_CODE
OVER_SHIP_ RESOLVED_FLAG	OE_ORDER_ LINES_ALL	OVER_SHIP_ RESOLVED_FLAG
AUTHORIZED_TO_ SHIP_FLAG	OE_ORDER_ LINES_ALL	AUTHORIZED_ TO_SHIP_FLAG	Indicates whether the demand lines are authorized to ship.
SHIP_TOLERANCE_ ABOVE	OE_ORDER_ LINES_ALL	SHIP_ TOLERANCE_ ABOVE	Over shipment or return tolerance.
SHIP_TOLERANCE_ BELOW	OE_ORDER_ LINES_ALL	SHIP_ TOLERANCE_ BELOW	Under shipment or return tolerance.
SHIP_SET_NAME	OE_SETS	SET_NAME
ARRIVAL_SET_NAME	OE_SETS	SET_NAME
PRICE_LIST	QP_LIST_ HEADERS_VL	NAME
PRICING_DATE	OE_ORDER_ LINES_ALL	PRICING_DATE
UNIT_LIST_PRICE	OE_ORDER_ LINES_ALL	UNIT_LIST_ PRICE
UNIT_LIST_PRICE_ PER_PQTY	OE_ORDER_ LINES_ALL	UNIT_LIST_ PRICE_PER_ PQTY
UNIT_SELLING_PRICE	OE_ORDER_ LINES_ALL	UNIT_SELLING_ PRICE
UNIT_SELLING_PRICE_ PER_PQTY	OE_ORDER_ LINES_ALL	UNIT_SELLING_ PRICE_PER_ PQTY
TAX_DATE	OE_ORDER_ LINES_ALL	TAX_DATE
TAX_CODE	OE_ORDER_ LINES_ALL	TAX_CODE
TAX_VALUE	OE_ORDER_ LINES_ALL	TAX_VALUE
CALCULATED_PRICE_ FLAG			Indicates if price is to be calculated. Not used for outbound transactions.
TAX_EXEMPT_FLAG	OE_ORDER_ LINES_ALL	TAX_EXEMPT_ FLAG	For the order line. Use: S for Standard E for Exempt R for Required
TAX_EXEMPT_NUMBER	OE_ORDER_ LINES_ALL	TAX_EXEMPT_ NUMBER	Tax exemption number.
TAX_EXEMPT_ REASON_CODE	OE_ORDER_ LINES_ALL	TAX_EXEMPT_ REASON_CODE	Tax exemption reason code.
TAX_EXEMPT_ REASON	AR_LOOKUPS	MEANING	Tax exemption reason.
TAX_POINT_CODE	OE_ORDER_ LINES_ALL	TAX_POINT_CODE
TAX_POINT	OE_LOOKUPS	MEANING
AGREEMENT	OE_AGREEMENTS_ TL	NAME
ACCOUNTING_RULE	RA_RULES	MEANING
INVOICING_RULE	RA_RULES	MEANING
PAYMENT_TERM	RA_TERMS_TL	NAME
DEMAND_CLASS_ CODE	OE_ORDER_ LINES_ALL	DEMAND_CLASS_ CODE
DEMAND_CLASS	OE_FND_COMMON_ LOOKUPS_V	MEANING
SHIPMENT_PRIORITY_ CODE	OE_ORDER_ LINES_ALL	SHIPMENT_ PRIORITY_CODE
SHIPMENT_PRIORITY	OE_LOOKUPS	MEANING
SHIPPING_METHOD_ CODE	OE_ORDER_ LINES_ALL	SHIPPING_ METHOD_CODE
SHIPPING_METHOD	OE_LOOKUPS	MEANING
FREIGHT_CARRIER_ CODE	OE_ORDER_ LINES_ALL	FREIGHT_ CARRIER_CODE
FREIGHT_CARRIER	ORG_FREIGHT	DESCRIPTION
FREIGHT_TERMS_ CODE	OE_ORDER_ LINES_ALL	FREIGHT_ TERMS_CODE
FREIGHT_TERMS	OE_LOOKUPS	MEANING
FOB_POINT_CODE	OE_ORDER_ LINES_ALL	FOB_POINT_CODE
FOB_POINT	AR_LOOKUPS	MEANING
SALESREP	RA_SALESREPS_ALL	NAME	Sales representative’s name.
SHIPPING_ INSTRUCTIONS	OE_ORDER_ LINES_ALL	SHIPPING_ INSTRUCTIONS
PACKING_ INSTRUCTIONS	OE_ORDER_ LINES_ALL	PACKING_ INSTRUCTIONS
RETURN_REASON_ CODE	OE_ORDER_ LINES_ALL	RETURN_ REASON_CODE
RETURN_REASON	FND_LOOKUP_VALUES	MEANING
REFERENCE_TYPE	OE_ORDER_ LINES_ALL	REFERENCE_ TYPE
REFERENCE_HEADER	OE_ORDER_ HEADERS_ALL	ORIG_SYS_ DOCUMENT_REF	Sales order header that the return line references.
REFERENCE_LINE	OE_ORDER_ LINES_ALL	ORIG_SYS_ LINE_REF	Sales order line that the return line references.
CREDIT_INVOICE_ NUMBER	HZ_CUST_ ACCOUNT_TRX_ALL	TRX_NUMBER
CUSTOMER_LINE_ NUMBER	OE_ORDER_ LINES_ALL	CUSTOMER_ LINE_NUMBER	Sales order line number.
CUSTOMER_PO_ NUMBER	OE_ORDER_ LINES_ALL	CUST_PO_ NUMBER	Sales order purchase number.
CUSTOMER_SHIPMENT_ NUMBER	OE_ORDER_ LINES_ALL	CUSTOMER_ SHIPMENT_ NUMBER	Sales order shipment number.
CUSTOMER_ITEM_ NAME	MTL_ CUSTOMER_ ITEMS	CUSTOMER_ ITEM_NUMBER	Sales order item name.
CUSTOMER_ITEM_ REVISION			Sales order item revision.Not used for outbound transactions.
CUSTOMER_ITEM_ NET_PRICE	OE_ORDER_ LINES_ALL	CUSTOMER_ ITEM_NET_ PRICE	Sales order item net price.
DEMAND_BUCKET_ TYPE_CODE	OE_ORDER_ LINES_ALL	DEMAND_ BUCKET_ TYPE_CODE	Demand bucket type code.
CUSTOMER_DOCK_ CODE	OE_ORDER_ LINES_ALL	CUSTOMER_ DOCK_CODE	Sales order dock code.
CUSTOMER_JOB	OE_ORDER_ LINES_ALL	CUSTOMER_ JOB	Sales order job.
CUSTOMER_ PRODUCTION_LINE	OE_ORDER_ LINES_ALL	CUSTOMER_ PRODUCTION_ LINE	Sales order production line.
CUST_MODEL_ SERIAL_NUMBER	OE_ORDER_ LINES_ALL	CUST_MODEL_ SERIAL_NUMBER	Sales order model serial number.
PROJECT	PA_PROJECTS_ ALL	NAME	Project name.
TASK	PA_TASKS	TASK_NAME	Task name.
FULFILLMENT_ SET_NAME	OE_SETS	SET_NAME	Fulfillment set name.
END_ITEM_UNIT_ NUMBER	OE_ORDER_ LINES_ALL	END_ITEM_ UNIT_NUMBER	Bill of material for building a specific mode or unit number controlled item.
ITEM_REVISION	OE_ORDER_ LINES_ALL	ITEM_REVISION	Item revision for a return line.
SCHEDULE_DATE			Not used for outbound transactions.
SHIP_TO_CONTACT_ AREA_CODE1			Ship To contact area 1. Not used for outbound transactions.
SHIP_TO_CONTACT_ AREA_CODE2			Ship To contact area 2. Not used for outbound transactions.
SHIP_TO_CONTACT_ AREA_CODE3			Ship To contact area 3. Not used for outbound transactions.
CUSTOMER_ITEM_ ID_TYPE			Sales order item type. Not used for outbound transactions.
INVOICE_SET_NAME			Invoice set name. Not used for outbound transactions.
TAX			Not used for outbound transactions.
SCHEDULE_ITEM_ DETAIL			Not used for outbound transactions.
DEMAND_STREAM			Not used for outbound transactions.
SERVICE_DURATION	OE_ORDER_ LINES_ALL	SERVICE_ DURATION
SERVICE_START_DATE	OE_ORDER_ LINES_ALL	SERVICE_ START_DATE
SERVICE_END_DATE	OE_ORDER_ LINES_ALL	SERVICE_ END_DATE
SERVICE_COTERMINATE_ FLAG	OE_ORDER_ LINES_ALL	SERVICE_ COTERMINATE_ FLAG
UNIT_SELLING_ PERCENT	OE_ORDER_ LINES_ALL	UNIT_ SELLING_ PERCENT	Percent actually charged to sales order for percent- based pricing.
UNIT_LIST_PERCENT	OE_ORDER_ LINES_ALL	UNIT_LIST_ PERCENT	Price list percentage of the item for percent–based pricing.
UNIT_PERCENT_ BASE_PRICE	OE_ORDER_ LINES_ALL	UNIT_PERCENT_ BASE_PRICE	Base price used for percent-based pricing.
SERVICE_NUMBER	OE_ORDER_ LINES_ALL	SERVICE_ NUMBER	Unique number to identify the service line.
CANCELLED_FLAG	OE_ORDER_ LINES_ALL	CANCELLED_ FLAG	Indicates whether the line was cancelled.
FULFILLED_FLAG	OE_ORDER_ LINES_ALL	FULFILLED_ FLAG	Indicates whether the line was fulfilled.
SERVICE_TXN_ REASON_CODE	OE_ORDER_ LINES_ALL	SERVICE_TXN_ REASON_CODE	Service transaction reason code.
SERVICE_TXN_ COMMENTS	OE_ORDER_ LINES_ALL	SERVICE_TXN_ COMMENTS	Service transaction comments.
CLOSED_FLAG			Indicates the line was closed. Not used for outbound transactions.
CONTRACT_PO_ NUMBER			Contract purchase order number. Not used for outbound transactions.
LINE_PO_CONTEXT			Line purchase order context. Not used for outbound transactions.
OPERATION_CODE			Not used for outbound transactions.
CHANGE_REASON			Not used for outbound transactions.
CHANGE_COMMENTS			Not used for outbound transactions.
REJECTED_FLAG			Not used for outbound transactions.
STATUS_FLAG			Not used for outbound transactions.

1.1.1 PRICE_ADJ

Field Name	Oracle Applications Table/View Name	Column Name	Description
HEADER_ID	OE_PRICE_ ADJUSTMENTS	HEADER_ID	Order header identifier that is the same HEADER_ID as the one on the order.
LINE_ID	OE_PRICE_ ADJUSTMENTS	LINE_ID	Order line identifier that is the same LINE_ID as the one on the order line.
ADJUSTED_ AMOUNT	OE_PRICE_ ADJUSTMENTS	ADJUSTED_ AMOUNT	Adjusted amount at the adjustment level.
ADJUSTED_ AMOUNT_PER_PQTY	OE_PRICE_ ADJUSTMENTS	ADJUSTED_ AMOUNT_ PER_PQTY	Adjusted amount per quantity.
APPLIED_FLAG	OE_PRICE_ ADJUSTMENTS	APPLIED_FLAG	Indicates whether the adjustment has been applied to the order line. For string manual discounts, which are not yet applied by the user.
ARITHMETIC_ OPERATOR	OE_PRICE_ ADJUSTMENTS	ARITHMETIC_ OPERATOR	Qualifies the value in operand by using percentage, amount, or new price.
AUTOMATIC_FLAG	OE_PRICE_ ADJUSTMENTS	AUTOMATIC_FLAG	Indicates whether the discount was applied automatically.
CHANGE_REASON_ CODE	OE_PRICE_ ADJUSTMENTS	CHANGE_REASON_ CODE	Reason code for making a change to the adjustment value.
CHANGE_REASON_ TEXT	OE_PRICE_ ADJUSTMENTS	CHANGE_REASON_ TEXT	Description of reason code.
CHANGE_REQUEST_ CODE			Not used for outbound transactions.
CHANGE_SEQUENCE			Not used for outbound transactions.
CHARGE_TYPE_CODE	OE_PRICE_ ADJUSTMENTS	CHARGE_TYPE_ CODE
CHARGE_SUBTYPE_ CODE	OE_PRICE_ ADJUSTMENTS	CHARGE_SUBTYPE_ CODE
COST_TYPE	WSH_FREIGHT_ COST_TYPES	FREIGHT_COST_ TYPE_CODE	Freight cost type.
COST_UNIT_AMOUNT	WSH_FREIGHT_ COSTS	UNIT_AMOUNT	Amount for freight costs in unit.
COST_QUANTITY	WSH_FREIGHT_ COSTS	QUANTITY
COST_AMOUNT	WSH_FREIGHT_ COSTS	TOTAL_AMOUNT	The total amount of freight cost is the freight cost unit amount multiplied by the freight quantity.
COST_CURRENCY_ CODE	WSH_FREIGHT_ COSTS	CURRENCY_ CODE	Freight cost currency code.
CREDIT_OR_CHARGE_ FLAG	OE_PRICE_ ADJUSTMENTS	CREDIT_OR_ CHARGE_FLAG	Indicates whether the adjustment record is a credit or charge to a sales order.
DISCOUNT_NAME	SO_DISCOUNTS	NAME
LINE_DISCOUNT_NAME	SO_DISCOUNTS	NAME
ESTIMATED_FLAG	OE_PRICE_ ADJUSTMENTS	ESTIMATED_ FLAG	Indicates whether the charge amount is estimated or fixed.
INVOICED_FLAG	OE_PRICE_ ADJUSTMENTS	INVOICED_ FLAG	Indicates whether the charge is invoiced.
INC_IN_SALES_ PERFORMANCE	OE_PRICE_ ADJUSTMENTS	INC_IN_SALES_ PERFORMANCE	Indicates whether the charge should be included in sales performance calculation.
INCLUDE_ON_ RETURNS_FLAG	OE_PRICE_ ADJUSTMENTS	INCLUDE_ON_ RETURNS_FLAG	Indicates whether the adjustment is returnable.
LIST_NAME	QP_LIST_HEADERS_TL	NAME	Name of modifier.
LIST_LINE_TYPE_ CODE	OE_PRICE_ ADJUSTMENTS	LIST_LINE_ TYPE_CODE	Line type of the modifier.
LIST_LINE_NUMBER	OE_PRICE_ ADJUSTMENTS	LIST_LINE_NO
MODIFIED_FROM	OE_PRICE_ ADJUSTMENTS	MODIFIED_FROM	Stores the value of the upgraded item code.
MODIFIED_TO	OE_PRICE_ ADJUSTMENTS	MODIFIED_TO	Stores the value of the upgraded item code.
MODIFIER_ MECHANISM_ TYPE_CODE	OE_PRICE_ ADJUSTMENTS	MODIFIER_ MECHANISM_ TYPE_CODE
OPERAND	OE_PRICE_ ADJUSTMENTS	OPERAND	Stores the adjustment value, qualified by an arithmetic operator.
OPERAND_ PER_PQTY	OE_PRICE_ ADJUSTMENTS	OPERAND_ PER_PQTY	Operand per quantity.
OPERATION_CODE			Not used for outbound transactions.
ORDER_SOURCE	OE_ORDER_ SOURCES	NAME	Order source name that is the same as the one in the order.
ORIG_SYS_ DISCOUNT_REF	OE_PRICE_ ADJUSTMENTS	ORIG_SYS_ DISCOUNT_REF	Original system discount reference.
PARENT_ ADJUSTMENT_ NAME	QP_LIST_ HEADERS_TL	NAME	Parent adjustment name.
PRICING_PHASE	QP_PRICING_ PHASES	NAME	Pricing phase name.
PERCENT	OE_PRICE_ ADJUSTMENTS	PERCENT	Percentage.
TAX_CODE	OE_PRICE_ ADJUSTMENTS	TAX_CODE	Tax code for the charges.
UPDATE_ ALLOWED	OE_PRICE_ ADJUSTMENTS	UPDATE_ ALLOWED	Indicates whether this adjustment can be overridden.
UPDATED_FLAG	OE_PRICE_ ADJUSTMENTS	UPDATED_ FLAG	Indicates whether the user has modified this row.
VERSION_NUMBER			Not used for outbound transactions.
STATUS_FLAG			Not used for outbound transactions.
FREIGHT_CODE		COST_ID

1.1.2 PRICE_ATTRIBS

Field Name	Oracle Applications Table/View Name	Column Name	Description
HEADER_ID	OE_ORDER_ PRICE_ATTRIBS	HEADER_ID	Order header identifier that is the same as the HEADER_ID in the order.
LINE_ID	OE_ORDER_ PRICE_ATTRIBS	LINE_ID	Order line identifier that is the same as the LINE_ID in the order lines.
ORIG_SYS_ATTS_REF	OE_ORDER_ PRICE_ATTRIBS	ORIG_SYS_ ATTS_REF	Original System Attribute Reference.
ORDER_SOURCE	OE_ORDER_ SOURCES	NAME	Order source name that is the same as the one in the order.
CHANGE_REQUEST_ CODE			Not used for outbound transactions.
CHANGE_SEQUENCE			Not used for outbound transactions.
OPERATION_CODE			Not used for outbound transactions.
STATUS_FLAG			Not used for outbound transactions.
FLEX_TITLE	OE_ORDER_ LINES_ALL	FLEX_TITLE	Name of the pricing context’s flex structure.
PRICING_CONTEXT	OE_ORDER_ LINES_ALL	PRICING_ CONTEXT

1.1.3 LOTSERIALS

Field Name	Oracle Applications Table/View Name	Column Name	Description
ORDER_SOURCE	OE_ORDER_ SOURCES	NAME	Order source name that is the same as the one in the order.
ORIG_SYS_ LOTSERIAL_REF	OE_LOT_ SERIAL_ NUMBERS	ORIG_SYS_ LOTSERIAL_REF	Original system lot serial reference.
LOT_NUMBER	OE_LOT_ SERIAL_ NUMBERS	LOT_NUMBER
LINE_ID	OE_LOT_ SERIAL_ NUMBERS	LINE_ID	Order line identifier that is the same as the LINE_ID in the order lines.
FROM_SERIAL_NUMBER	OE_LOT_ SERIAL_ NUMBERS	FROM_ SERIAL_ NUMBER	Serial number range starting number. If TO_SERIAL_NUMBER is null, then the only serial number is FROM_SERIAL_NUMBER.
TO_SERIAL_NUMBER	OE_LOT_ SERIAL_ NUMBERS	TO_SERIAL_ NUMBER	Serial number range ending number.
QUANTITY	OE_LOT_ SERIAL_ NUMBERS	QUANTITY	Lot or serial number quantity. This should match the serial number range for serial number controlled items.
CHANGE_REQUEST_CODE			Not used for outbound transactions.
CHANGE_SEQUENCE			Not used for outbound transactions.
OPERATION_CODE			Not used for outbound transactions.
STATUS_FLAG			Not used for outbound transactions.

1.1.4 SALES_CREDITS

Field Name	Oracle Applications Table/View Name	Column Name	Description
HEADER_ID	OE_SALES_ CREDITS	HEADER_ID	Order header identifier that is the same as the HEADER_ID in the order.
LINE_ID	OE_SALES_ CREDITS	LINE_ID	Order line identifier that is the same as the LINE_ID in the order lines.
ORIG_SYS_ CREDIT_REF	OE_SALES_ CREDITS	ORIG_SYS_ CREDIT_REF	Original System Credit Reference.
ORDER_SOURCE	OE_ORDER_ SOURCES	NAME	Order source name that is the same as the one in the order.
QUOTA_FLAG	OE_SALES_ CREDITS	QUOTA_FLAG	Indicates revenue or non-revenue based credit.
PERCENT	OE_SALES_ CREDITS	PERCENT	Indicates sales credit percentage for a sales representative.
SALESREP	RA_SALESREPS_ ALL	NAME	Sales representative’s name.
SALES_CREDIT_TYPE	OE_SALES_ CREDIT_TYPES	NAME	Sales credit type.
CHANGE_REQUEST_ CODE			Not used for outbound transactions.
CHANGE_SEQUENCE			Not used for outbound transactions.
OPERATION_CODE			Not used for outbound transactions.
STATUS_FLAG			Not used for outbound transactions.

1.1.5 OE_RESERVTNS

Field Name	Oracle Applications Table/View Name	Column Name	Description
HEADER_ID	MTL_RESERVATIONS	DEMAND_ SOURCE_ HEADER_ID	Order header identifier that is the same as the HEADER_ID in the order.
LINE_ID	MTL_RESERVATIONS	DEMAND_ SOURCE_ LINE_ID	Order line identifier that is the same as the LINE_ID in the order lines.
ORDER_SOURCE	OE_ORDER_ SOURCES	NAME	Order source name that is the same the one in the order.
REVISION	MTL_RESERVATIONS	REVISION	For revision controlled reserved item.
ITEM_CODE	MTL_SYSTEM_ ITEMS_B_KFV	CONCATENATED_ SEGMENTS	Reserved item.
SUBINVENTORY_ CODE	MTL_RESERVATIONS	SUBINVENTORY_ CODE	Subinventory where reserved item resides.
LOCATOR	MTL_ITEM_ LOCATIONS_KFV	CONCATENATED_ SEGMENTS	Locator where reserved item resides.
LOT_NUMBER	MTL_RESERVATIONS	LOT_NUMBER	For lot controlled reserved item.
QUANTITY	MTL_RESERVATIONS	RESERVATION_ QUANTITY	Quantity reserved.
ORIG_SYS_ RESERVATION_REF			Original System Reservation Reference. Not used for outbound.
CHANGE_SEQUENCE			Not used for outbound transactions.
OPERATION_CODE			Not used for outbound transactions.

1.1.6 OE_LINE_ACTIONS

Field Name	Oracle Applications Table/View Name	Column Name	Description
HEADER_ID	OE_ORDER_ HEADERS_ALL	HEADER_ID	Order header identifier that is the same as the HEADER_ID in the order.
LINE_ID	OE_ORDER_ LINES_ALL	LINE_ID	Order line identifier that is the same as the LINE_ID in the order lines.
ORDER_SOURCE			Not used for outbound transactions.
CHANGE_SEQUENCE			Not used for outbound transactions.
HOLD_NAME			Not used for outbound transactions.
HOLD_TYPE_CODE			Not used for outbound transactions.
HOLD_UNTIL_DATE			Not used for outbound transactions.
RELEASE_REASON_CODE			Not used for outbound transactions.
COMMENTS			Not used for outbound transactions.
CONTEXT			Not used for outbound transactions.
OPERATION_CODE			Not used for outbound transactions.
STATUS_FLAG			Not used for outbound transactions.