Script | Description |
wm_install_from_orderstatus.sql | Runs the scripts listed below, except the uninstall script. |
wm_from_orderstatus_vw.sql | Creates the required view component WM_OS_QRY_VW. |
wm_from_orderstatus_pkg.sql | Installs the WM_ORDER_STATUS_PKG.get_po_status procedure to retrieve the Purchase Order Status. |
wm_drop_from_orderstatus.sql | Uninstalls all components created by wm_install_from_orderstatus.sql. |
Document Field | Oracle Applications Table/View Name | Column Name | Description |
PO_DOCUMENT_ NUM | PO_HEADERS_ ALL | SEGMENT1 | Purchase order number. |
REVISION_NUM | PO_HEADERS_ ALL | REVISION_NUM | Purchase order revision number. |
TYPE_LOOKUP_ CODE | PO_HEADERS_ ALL | TYPE_LOOKUP_ CODE | Purchase order type (e.g., STANDARD, BLANKET, PLANNED, CONTRACT) |
CREATION_DATE_ DISP | PO_HEADERS_ ALL | CREATION_DATE | Purchase order creation date. |
ORGANIZATION_ NAME | PO_HEADERS_ ALL | ORG_ID | Organization name for which the PO is generated. |
VENDOR_NAME | PO_HEADERS_ ALL | VENDOR_ID | Supplier name. |
VENDOR_SITE_ CODE | PO_HEADERS_ ALL | VENDOR_SITE_ ID | Supplier site code. |
VENDOR_ CONTACT | PO_HEADERS_ ALL | VENDOR_ CONTACT_ID | Supplier contact name. |
CURRENCY_ CODE | PO_HEADERS_ ALL | CURRENCY_ CODE | |
AGENT_NAME | PO_HEADERS_ALL | AGENT_ID | Buyer name. |
PO_STATUS | PO_HEADERS_ ALL | STATUS_ LOOKUP_CODE | Purchase order status. |
BLANKET_TOTAL_ AMOUNT | PO_HEADERS_ ALL | BLANKET_TOTAL_ AMOUNT | Amount agreed for the purchase order. |
COMMENTS | PO_HEADERS_ ALL | COMMENTS | |
SHIP_TO_ ADDRESS_LINE_1 | PO_HEADERS_ ALL | SHIP_TO_ LOCATION_ID | Shipping location details. |
SHIP_TO_ ADDRESS_LINE_2 | |||
SHIP_TO_ ADDRESS_LINE_3 | |||
SHIP_TO_ TOWN_OR_CITY | |||
SHIP_TO_REGION_1 | |||
SHIP_TO_REGION_2 | |||
SHIP_TO_REGION_3 | |||
SHIP_TO_COUNTRY | |||
SHIP_TO_POSTAL_CODE | |||
BILL_TO_ ADDRESS_LINE_1 | PO_HEADERS_ ALL | BILL_TO_ LOCATION_ID | Billing location details. |
BILL_TO_ ADDRESS_LINE_2 | |||
BILL_TO_ ADDRESS_LINE_3 | |||
BILL_TO_ TOWN_OR_CITY | |||
BILL_TO_REGION_1 | |||
BILL_TO_REGION_2 | |||
BILL_TO_REGION_3 | |||
BILL_TO_COUNTRY | |||
BILL_TO_POSTAL_CODE | |||
SUPPLIER_ ADDRESS_LINE1 | PO_HEADERS_ ALL | VENDOR_SITE_ ID | Purchase order vendor site details. |
SUPPLIER_ ADDRESS_LINE2 | |||
SUPPLIER_ ADDRESS_LINE3 | |||
SUPPLIER_CITY | |||
SUPPLIER_STATE | |||
SUPPLIER_ZIP | |||
SUPPLIER_COUNTRY |