RF_IPTREE_ALLVW

(SQL View)
 Index Back

Installed Product Tree View

This view returns all installed products for all customers on the Installed Product Hierarchy.

SELECT A.SETID , A.INST_PROD_ID , B.BO_NAME , D.BO_NAME_DISPLAY , E.BO_NAME , A.PRODUCT_ID , C.DESCR , A.SERIAL_ID , A.ASSETTAG FROM PS_RF_INST_PROD A , PS_BO_NAME B , PS_BO_NAME D , PS_RF_SITE_P_NM_VW E , PS_PROD_ITEM C WHERE A.BO_ID_CUST = B.BO_ID(+) AND B.PRIMARY_IND(+) = 'Y' AND A.BO_ID_CONTACT = D.BO_ID(+) AND D.PRIMARY_IND(+) = 'Y' AND A.SETID = E.SETCNTRLVALUE(+) AND A.SITE_ID = E.SITE_ID(+) AND C.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.SETID AND D.RECNAME='PROD_ITEM') AND C.PRODUCT_ID = A.PRODUCT_ID

  • Related Language Record: RF_IPTREE_A_LVW

    • # 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.
    2 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
    3 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
    5 BO_NAME_2 Character(50) VARCHAR2(50) NOT NULL BO Name 2
    6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product
    9 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag