RBT_INSTACT_LVW

(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 , LANGUAGE_CD , p.DESCR , i.LOCN FROM PS_RF_INST_PROD i , PS_PROD_ITEM_LNG 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 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 for RBT_INST_ACT_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 LOCN Character(70) VARCHAR2(70) NOT NULL Physical Location