RBT_INST_ACT_VW

(SQL View)
 Index Back

Active Installed Services View

View to retrieve all the Installed Services that are services and which are in Active Status

SELECT d.BO_ID , i.BO_ID_CUST , i.INST_PROD_ID , i.BO_ID_CONTACT , i.RBTACCTID , i.PRODUCT_ID , p.DESCR , h.INST_PROD_STATUS , i.LOCN FROM PS_RF_INST_PROD i , PS_PROD_ITEM p , PS_RBT_PROD_ITEM pt , PS_RD_SITE d , PS_RF_INST_PROD_ST h WHERE p.SETID = ( SELECT x.SETID FROM PS_SET_CNTRL_REC x WHERE x.SETCNTRLVALUE = i.SETID AND x.RECNAME = 'PROD_ITEM') AND i.PRODUCT_ID = p.PRODUCT_ID AND p.SETID = pt.SETID AND p.PRODUCT_ID = pt.PRODUCT_ID AND h.SETID = i.SETID AND h.INST_PROD_ID = i.INST_PROD_ID AND p.SERVICE = 'Y' AND pt.RBTFEATURE_FLAG = 'N' AND d.SETID = ( SELECT y.SETID FROM PS_SET_CNTRL_REC y WHERE y.SETCNTRLVALUE = i.SETID AND y.RECNAME = 'RD_SITE') AND i.SITE_ID=d.SITE_ID AND i.RBTACCTID <> ' '

  • Related Language Record: RBT_INSTACT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID
    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)

    Prompt Table: RBT_INST_SRV_VW
    Set Control Field: INST_PROD_ID

    4 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    5 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier

    Prompt Table: RBT_ACCOUNT

    6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: RF_PROD_PMPT_VW

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.
    9 LOCN Character(70) VARCHAR2(70) NOT NULL Physical Location