Send Advance Shipping Notice Service

Document Field	Oracle Applications Table/View Name	Column Name	Description
WEB_TRANSACTION_ ID
DOCUMENT_TYPE			Use ASN.
DOCUMENT_STATUS			Use INSERT.
ORDER_LINE_ID	WSH_DELIVERY_ DETAILS	SOURCE_LINE_ID
ORDER_NUMBER	OE_ORDER_ HEADERS_ALL	ORDER_NUMBER	User–visible number of the order.
ORDER_LINE_ NUMBER	WSH_DELIVERY_ DETAILS	SOURCE_LINE_ NUMBER	Line sequence number within the order.
PURCHASE_ORDER_ NUMBER	OE_ORDER_ HEADERS_ALL	CUST_PO_ NUMBER	Customer purchase order number.
ORDER_DATE	OE_ORDER_ HEADERS_ALL	ORDERED_DATE
ORDER_STATUS	OE_ORDER_ HEADERS_ALL	FLOW_STATUS_ CODE
FREIGHT_TERMS_ CODE_INT	OE_ORDER_ HEADERS_ALL	FREIGHT_TERMS_ CODE
FOB_CODE_INT	OE_ORDER_ HEADERS_ALL	FOB_POINT_CODE	Free on Board point code.
SHIP_METHOD_INT	OE_ORDER_ HEADERS_ALL	SHIPPING_ METHOD_CODE	Shipping method.
CONVERSION_RATE	OE_ORDER_ HEADERS_ALL	CONVERSION_RATE
CURRENCY_CODE	OE_ORDER_ HEADERS_ALL	TRANSACTIONAL_ CURR_CODE
ORGANIZATION_ NAME	HR_ALL_ ORGANIZATION_ UNITS	NAME	Operating unit that performed this transaction.
CUSTOMER_NUMBER	HZ_CUST_ ACCOUNTS	ACCOUNT_ NUMBER
CUSTOMER_NAME	HZ_PARTIES	PARTY_NAME	Name of customer who placed the order.
INVOICE_CODE_INT	HZ_CUST_ ACCT_SITES_ ALL	ORIG_SYSTEM_ REFERENCE	Invoice recipient’s location internal code.
INVOICE_CODE_EXT	HZ_CUST_ ACCT_SITES_ ALL	ECE_TP_LOCATION_ CODE	Invoice recipient’s location external code.
INVOICE_NAME	HZ_CUST_ ACCT_SITES_ ALL	LOCATION	Invoice recipient’s location name.
INVOICE_ADDRESS1	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS1	Invoice recipient’s address line 1.
INVOICE_ADDRESS2	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS2	Invoice recipient’s address line 2.
INVOICE_ADDRESS3	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS3	Invoice recipient’s address line 3.
INVOICE_ADDRESS4	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS4	Invoice recipient’s address line 4.
INVOICE_CITY	HZ_CUST_ ACCT_SITES_ ALL	CITY	Invoice recipient’s city.
INVOICE_POSTAL_ CODE	HZ_CUST_ ACCT_SITES_ ALL	POSTAL_CODE	Invoice recipient’s postal code.
INVOICE_COUNTRY_ INT	HZ_CUST_ ACCT_SITES_ ALL	COUNTRY	Invoice recipient’s country.
INVOICE_STATE_ INT	HZ_CUST_ ACCT_SITES_ ALL	STATE	Invoice recipient’s state.
INVOICE_PROVINCE_ INT	HZ_CUST_ ACCT_SITES_ ALL	PROVINCE	Invoice recipient’s province.
INVOICE_COUNTY	HZ_CUST_ ACCT_SITES_ ALL	COUNTY	Invoice recipient’s county.
INVOICE_CONTACT_ LAST_NAME	HZ_PARTIES	PERSON_LAST_ NAME	Invoice recipient’s last name.
INVOICE_CONTACT_ PERSON_FIRST_NAME	HZ_PARTIES	PERSON_FIRST_ NAME	Invoice recipient’s first name.
INVOICE_CONTACT_ JOB_TITLE	HZ_ORG_ CONTACTS	JOB_TITLE	Invoice recipient’s job title.
ORDER_BY_CODE_INT	HZ_CUST_ ACCT_SITES_ ALL	ORIG_SYSTEM_ REFERENCE	Order recipient’s location internal code.
ORDER_BY_CODE_EXT	HZ_CUST_ ACCT_SITES_ ALL	ECE_TP_ LOCATION_ CODE	Order recipient’s location external code.
ORDER_BY_ADDRESS1	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS1	Order recipient’s address line 1.
ORDER_BY_ADDRESS2	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS2	Order recipient’s address line 2.
ORDER_BY_ADDRESS3	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS3	Order recipient’s address line 3.
ORDER_BY_ADDRESS4	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS4	Order recipient’s address line 4.
ORDER_BY_CITY	HZ_CUST_ ACCT_SITES_ ALL	CITY	Order recipient’s city.
ORDER_BY_POSTAL_ CODE	HZ_CUST_ ACCT_SITES_ ALL	POSTAL_CODE	Order recipient’s postal code.
ORDER_BY_ COUNTRY_INT	HZ_CUST_ ACCT_SITES_ ALL	COUNTRY	Order recipient’s country.
ORDER_BY_ STATE_INT	HZ_CUST_ ACCT_SITES_ ALL	STATE	Order recipient’s state.
ORDER_BY_ PROVINCE_INT	HZ_CUST_ ACCT_SITES_ ALL	PROVINCE	Order recipient’s province.
ORDER_BY_COUNTY	HZ_CUST_ ACCT_SITES_ ALL	COUNTY	Order recipient’s county.
ORDER_BY_CONTACT_ LAST_NAME	HZ_PARTIES	PERSON_ LAST_NAME	Order recipient’s last name.
ORDER_BY_CONTACT_ FIRST_NAME	HZ_PARTIES	PERSON_ FIRST_NAME	Order recipient’s first name.
ORDER_BY_CONTACT_ JOB_TITLE	HZ_ORG_ CONTACTS	JOB_TITLE	Order recipient’s job title.
ORDER_SHIP_CODE_ INT	HZ_CUST_ ACCT_SITES_ ALL	ORIG_SYSTEM_ REFERENCE	Order recipient’s internal location code.
ORDER_SHIP_CODE_ EXT	HZ_CUST_ ACCT_SITES_ ALL	ECE_TP_ LOCATION_CODE	Order recipient’s external location code.
ORDER_SHIP_NAME	HZ_CUST_ ACCT_SITES_ ALL	LOCATION	Order recipient’s location name.
ORDER_SHIP_ ADDRESS1	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS1	Order recipient’s address line 1.
ORDER_SHIP_ ADDRESS2	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS2	Order recipient’s address line 2.
ORDER_SHIP_ ADDRESS3	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS3	Order recipient’s address line 3.
ORDER_SHIP_ ADDRESS4	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS4	Order recipient’s address line 4.
ORDER_SHIP_CITY	HZ_CUST_ ACCT_SITES_ ALL	CITY	Order recipient’s city.
ORDER_SHIP_ POSTAL_CODE	HZ_CUST_ ACCT_SITES_ ALL	POSTAL_CODE	Order recipient’s postal code.
ORDER_SHIP_ COUNTRY_INT	HZ_CUST_ ACCT_SITES_ ALL	COUNTRY	Order recipient’s country.
ORDER_SHIP_ STATE_INT	HZ_CUST_ ACCT_SITES_ ALL	STATE	Order recipient’s state.
ORDER_SHIP_ PROVINCE_INT	HZ_CUST_ ACCT_SITES_ ALL	PROVINCE	Order recipient’s province.
ORDER_SHIP_COUNTY	HZ_CUST_ ACCT_SITES_ ALL	COUNTY	Order recipient’s county.
ORDER_SHIP_ CONTACT_ LAST_NAME	HZ_PARTIES	PERSON_ LAST_NAME	Order recipient’s last name.
ORDER_SHIP_ CONTACT_ FIRST_NAME	HZ_PARTIES	PERSON_ FIRST_NAME	Order recipient’s first name.
ORDER_SHIP_ CONTACT_ JOB_TITLE	HZ_ORG_ CONTACTS	JOB_TITLE	Order recipient’s job title.
LINE_CREATION_ DATE	OE_ORDER_ LINES_ALL	CREATION_DATE	Order’s line creation date.
LINE_MODIFIED_ DATE	OE_ORDER_ LINES_ALL	LAST_ UPDATE_DATE	Order line’s last modified date.
LINE_ACTUAL_ SHIP_DATE	OE_ORDER_ LINES_ALL	ACTUAL_ SHIPMENT_ DATE	Order line’s actual shipment date.
LINE_REQUEST_ DATE	OE_ORDER_ LINES_ALL	REQUEST_DATE	Order line’s request date.
LINE_PROMISE_ DATE	OE_ORDER_ LINES_ALL	PROMISE_DATE	Date promised to customer to receive item.
LINE_SCHEDULED_ SHIP_DATE	OE_ORDER_ LINES_ALL	SCHEDULE_ SHIP_DATE	Date scheduled to ship item.
LINE_SHIPMENT_ METHOD	OE_ORDER_ LINES_ALL	SHIPPING_ METHOD_CODE
HOLD_CODE	WSH_DELIVERY_ DETAILS	HOLD_CODE
LINE_SHIP_CODE_INT	HZ_CUST_ ACCT_SITES_ ALL	ORIG_SYSTEM_ REFERENCE	Order line shipment recipient’s location internal code.
LINE_SHIP_CODE_EXT	HZ_CUST_ ACCT_SITES_ ALL	ECE_TP_ LOCATION_CODE	Order line shipment recipient’s location external code.
LINE_SHIP_NAME	HZ_CUST_ ACCT_SITES_ ALL	LOCATION	Order line shipment recipient’s location name.
LINE_SHIP_ADDRESS1	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS1	Order line shipment recipient’s address line 1.
LINE_SHIP_ADDRESS2	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS2	Order line shipment recipient’s address line 2.
LINE_SHIP_ADDRESS3	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS3	Order line shipment recipient’s address line 3.
LINE_SHIP_ADDRESS4	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS4	Order line shipment recipient’s address line 4.
LINE_SHIP_CITY	HZ_CUST_ ACCT_SITES_ ALL	CITY	Order line shipment recipient’s address city.
LINE_SHIP_POSTAL_ CODE	HZ_CUST_ ACCT_SITES_ ALL	POSTAL_CODE	Order line shipment recipient’s postal code.
LINE_SHIP_COUNTRY_ INT	HZ_CUST_ ACCT_SITES_ ALL	COUNTRY	Order line shipment recipient’s country.
LINE_SHIP_STATE_ INT	HZ_CUST_ ACCT_SITES_ ALL	STATE	Order line shipment recipient’s address state.
LINE_SHIP_PROVINCE_ INT	HZ_CUST_ ACCT_SITES_ ALL	PROVINCE	Order line shipment recipient’s province.
LINE_SHIP_COUNTY	HZ_CUST_ ACCT_SITES_ ALL	COUNTY	Order line shipment recipient’s county.
LINE_SHIP_CONTACT_ LAST_NAME	HZ_PARTIES	PERSON_LAST_ NAME	Order line shipment recipient’s last name.
LINE_SHIP_CONTACT_ FIRST_NAME	HZ_PARTIES	PERSON_FIRST_ NAME	Order line shipment recipient’s first name.
LINE_SHIP_CONTACT_ JOB_TITLE	HZ_ORG_ CONTACTS	JOB_TITLE	Order line shipment recipient’s contact job title.
NET_WEIGHT	WSH_DELIVERY_ DETAILS	NET_WEIGHT
GROSS_WEIGHT	WSH_DELIVERY_ DETAILS	GROSS_WEIGHT
TARE_WEIGHT	WSH_DELIVERY_ DETAILS	GROSS_WEIGHT_ NET_WEIGHT
WEIGHT_UOM	WSH_DELIVERY_ DETAILS	WEIGHT_UOM_ CODE	Weight unit of measure.
VOLUME	WSH_DELIVERY_ DETAILS	VOLUME
VOLUME_UOM	WSH_DELIVERY_ DETAILS	VOLUME_UOM_ CODE	Volume unit of measure.
SHIP_QUANTITY1	WSH_DELIVERY_ DETAILS	SHIPPED_ QUANTITY	Shipped quantity 1.
ORDERED_QUANTITY1	OE_ORDER_ LINES_ALL	ORDERED_ QUANTITY	Ordered quantity 1.
QUANTITY1_UOM	OE_ORDER_ LINES_ALL	ORDER_ QUANTITY_UOM	Unit of measure quantity 1.
SHIP_QUANTITY2	WSH_DELIVERY_ DETAILS	SHIPPED_ QUANTITY2	Shipped quantity 2.
ORDERED_QUANTITY2	OE_ORDER_LINES_ALL	ORDERED_ QUANTITY2	Ordered quantity 2.
QUANTITY2_UOM	OE_ORDER_LINES_ALL	ORDERED_ QUANTITY_ UOM2	Unit of measure quantity 2.
ITEM_DESCRIPTION	WSH_DELIVERY_ DETAILS	ITEM_DESCRIPTION	Ordered item description.
ITEM	MTL_SYSTEM_ ITEMS_B_KFV	CONCATENATED_ SEGMENTS	Ordered item code.
CUSTOMER_ITEM	MTL_CUSTOMER_ ITEMS	CUSTOMER_ ITEM_NUMBER
FROM_WAREHOUSE	MTL_ PARAMETERS	ORGANIZATION_ CODE	Warehouse code.
FROM_WAREHOUSE_ NAME	HR_ ORGANIZATION_ UNITS	NAME	Warehouse name.
WAREHOUSE_ ADDRESS1	HR_LOCATIONS_ ALL	ADDRESS_LINE_1	Warehouse address line 1.
WAREHOUSE_ ADDRESS2	HR_LOCATIONS_ ALL	ADDRESS_LINE_2	Warehouse address line 2.
WAREHOUSE_ ADDRESS3	HR_LOCATIONS_ ALL	ADDRESS_LINE_3	Warehouse address line 3.
WAREHOUSE_CITY	HR_LOCATIONS_ ALL	TOWN_OR_CITY	Warehouse city.
WAREHOUSE_POSTAL_ CODE	HR_LOCATIONS_ ALL	POSTAL_CODE	Warehouse postal code.
WAREHOUSE_ COUNTRY_INT	HR_LOCATIONS_ ALL	COUNTRY	Warehouse country.
WAREHOUSE_ REGION1_INT	HR_LOCATIONS_ ALL	REGION_1	Warehouse region 1.
WAREHOUSE_ REGION2_INT	HR_LOCATIONS_ ALL	REGION_2	Warehouse region 2.
WAREHOUSE_ REGION3_INT	HR_LOCATIONS_ ALL	REGION_3	Warehouse region 3.
WAREHOUSE_ TELEPHONE_1	HR_LOCATIONS_ ALL	TELEPHONE_ NUMBER_1	Warehouse telephone 1.
WAREHOUSE_ TELEPHONE_2	HR_LOCATIONS_ ALL	TELEPHONE_ NUMBER_2	Warehouse telephone 2.
WAREHOUSE_ TELEPHONE_3	HR_LOCATIONS_ ALL	TELEPHONE_ NUMBER_3	Warehouse telephone 3.
LIST_PRICE	OE_ORDER_ LINES_ALL	UNIT_LIST_PRICE
NET_TAX	OE_ORDER_ LINES_ALL	TAX_VALUE
UNIT_PRICE	OE_ORDER_ LINES_ALL	UNIT_SELLING_ PRICE	Unit sales price.
EXTENDED_PRICE	OE_ORDER_ LINES_ALL	UNIT_SELLING_ PRICE_PRICING_ QUANTITY
LOT_NUMBER	WSH_DELIVERY_ DETAILS	LOT_NUMBER
SUBLOT_NUMBER	WSH_DELIVERY_ DETAILS	SUBLOT_NUMBER
SHIP_SET_NAME	OE_SETS	SET_NAME

Database Script	Description
wm_install_from_shipnotice.sql	Runs all the scripts listed below, except the uninstall script.
wm_ship_notice_vw.sql	Creates all required views for the Advanced Shipping Notice outbound transactions: WM_ASN_DETAIL_VW WM_ASN_ORDER_QRY_VW
wm_ship_notice_trg.sql	Creates the WM_DELIVERY_DETAIL_U_TRG trigger to be used for writing to the WM_TRACKCHANGES table to indicate a new document.
wm_drop_from_shipnotice.sql	Uninstalls all components created by wm_install_from_shipnotice.sql.