OM_INTFC_CC_SR (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.

OM_INTFC_CC_SR

(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 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