RF_IPRD_VH_LVW

(SQL View)
 Index Back

Installed Prod Tree IP Node

This view is used in the creation of the Installed Product Tree. It returns installed products meeting the selection criteria.

SELECT A.SETID ,A.INST_PROD_ID ,E.LANGUAGE_CD ,E.DESCR ,E.DESCR254 FROM PS_RF_INST_PROD A , PS_PROD_ITEM_LNG E WHERE E.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.SETID AND D.RECNAME = 'PROD_ITEM') AND E.PRODUCT_ID = A.PRODUCT_ID

  • Related Language Record for RF_IPRD_VH_VW

    • # 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.

    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 Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254