Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter 12.2.7 Predefined Transaction Services Documentation | Procurement Predefined Transaction Services | Query Purchase Order Status Service
 
Query Purchase Order Status Service
This service is in the WmOAPRC1227 package and has the following fully-qualified service name: purchasing1227.queryOA.POStatus:queryPOStatus.
This service retrieves the purchase order status based on the following parameters:
*BUYER_NAME
*PO_DOCUMENT_NUM
*ORGANIZATION_NAME
*SHIP_TO_ADDRESS_LINE_1,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, 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, SUPPLIER_ADDRESS_LINE2, SUPPLIER_ADDRESS_LINE3
*SUPPLIER_CITY
*SUPPLIER_STATE
*SUPPLIER_ZIP
*SUPPLIER_COUNTRY
*SUPPLIER_NAME
Database Scripts
This service uses the following database scripts:
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.
For more information about using database scripts, see Database Scripts.
Supporting Transaction Definitions
This service uses the following transaction definition:
*queryPOStatusTxn1227.txp
For information about using the transaction definition files to customize this service, see Transaction Definitions.
Flow Control
You can query order status data using the following flow steps:
*specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
*queryOrderStatusTxn service queries the Oracle Applications database for any Order Status matching the parameter values. The parameters are defined as the input to this service.
For more details on query transactions, see Using Query Services.
Business Document Structure
This service uses the following business structure:
*PURCHASE_ORDER
PURCHASE_ORDER
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