RF_IPRDSRH_ALVW

(SQL View)
 Index Back

Installed Assets Search View

This view returns all Installed Assets. It is used as the Search view for the Installed Assets configurable search component.

SELECT A.SETID , A.INST_PROD_ID , P.LANGUAGE_CD , P.DESCR FROM PS_RF_INST_PROD A , PS_PROD_ITEM_LNG P WHERE P.SETID = ( SELECT R.SETID FROM PS_SET_CNTRL_REC R WHERE R.SETCNTRLVALUE = A.SETID AND R.RECNAME = 'PROD_ITEM') AND P.PRODUCT_ID = A.PRODUCT_ID AND A.INST_PROD_TYPE = '001'

  • Related Language Record for RF_IPRDSRH_ASVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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

    2 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR_PRODUCT Character(30) VARCHAR2(30) NOT NULL Description