RF_IPTREE_CUSVW

(SQL View)
 Index Back

Installed Product Tree View

This view returns all installed products for a given customer on the Installed Product Hierarchy.

SELECT A.SETID , A.BO_ID_CUST , A.INST_PROD_ID , B.BO_NAME , D.BO_NAME , A.PRODUCT_ID , C.DESCR , C.DESCR254 , A.SERIAL_ID , A.ASSETTAG FROM PS_RF_INST_PROD A , PS_RF_SITE_P_NM_VW D , PS_BO_NAME B , PS_PROD_ITEM C WHERE A.SETID = D.SETCNTRLVALUE(+) AND A.SITE_ID = D.SITE_ID(+) AND B.BO_ID = A.BO_ID_CUST AND B.PRIMARY_IND = 'Y' 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_IPTRCUS_VWLN

    • # 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 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    3 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
    4 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of 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 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    9 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product
    10 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag