ORD_TRACK_QRYSR (SQL View)	Index Back
Order Track RealTime Qry Srch This search dialog record is only used for the component interface ORDER_TRACK_QUERY which is associated with component ORDER_TRACKING. The operator default is placed here and since the field is entered, the dialog box is NOT displayed to the user when viewing the ORDER_TRACKING component. They are presented with a page from which to enter search criteria.

ORD_TRACK_QRYSR

(SQL View)

Order Track RealTime Qry Srch

This search dialog record is only used for the component interface ORDER_TRACK_QUERY which is associated with component ORDER_TRACKING. The operator default is placed here and since the field is entered, the dialog box is NOT displayed to the user when viewing the ORDER_TRACKING component. They are presented with a page from which to enter search criteria.

SELECT A.BUSINESS_UNIT , '9999999' FROM PS_BUS_UNIT_TBL_FS A , PS_BUS_UNIT_TBL_OM B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT
Prompt Table: SP_BU_OM_NONVW

2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop