RF_IPTREE_CNTVW

(SQL View)
 Index Back

Installed Product Tree View

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

SELECT A.SETID , A.BO_ID_CONTACT , A.INST_PROD_ID , B.BO_NAME_DISPLAY , A.PRODUCT_ID , C.DESCR , C.DESCR254 , A.SERIAL_ID , A.ASSETTAG FROM PS_RF_INST_PROD A , PS_BO_NAME B , PS_PROD_ITEM C WHERE B.BO_ID = A.BO_ID_CONTACT 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_IPTRCNT_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_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    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_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
    5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    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