RFM_PROD_DDR_VW

(SQL View)
Index Back

Mobile FieldService Products

This view returns all the Products that are referenced in the installed products for the customers in the user's open service orders

SELECT A.OPRID , A.SETID , A.PRODUCT_ID , A.SYNCID , A.SYNCDTTM , A.MARKET FROM PS_RFM_PROD_SET_VW A WHERE PRODUCT_ID IN ( SELECT DISTINCT PRODUCT_ID FROM PS_RFM_IPRD_DDR_VW B WHERE A.OPRID = B.OPRID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

Default Value: OPR_DEF_TBL_RB.SETID

Prompt Table: SP_SETID_NONVW

3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Default Value: NEXT

Prompt Table: PROD_SRCH_VW

4 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
5 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
6 MARKET Character(3) VARCHAR2(3) NOT NULL Market