RBT_INST_SRV_VW

(SQL View)
 Index Back

Installed Services View

This View is to get all the Installed Services (the parent) that are in Active or Suspend Status.

SELECT DISTINCT i.SETID , i.BO_ID_CUST , i.INST_PROD_ID , i.BO_ID_CONTACT , i.RBTACCTID , a.RBTACCTNO , i.PRODUCT_ID , p.DESCR , i.SITE_ID , i.LOCN , h.INST_PROD_STATUS , l.CONFIG_CODE , i.INSTALLED_DATE , i.SVC_END_DATE , k.RBTNUMBER , j.SERIAL_ID FROM PS_RF_INST_PROD i LEFT OUTER JOIN PS_RO_LINE l ON i.CAPTURE_ID = l.CAPTURE_ID AND i.LINE_NBR= l.LINE_NBR LEFT OUTER JOIN PS_RBT_ACCOUNT a ON i.RBTACCTID = a.RBTACCTID LEFT OUTER JOIN PS_RF_INST_PROD j ON i.INST_PROD_ID = j.PARENT_INST_PRODID LEFT OUTER JOIN PS_RF_INST_PROD k ON i.INST_PROD_ID = j.PARENT_INST_PRODID AND j.INST_PROD_ID = k.PARENT_INST_PRODID AND k.INST_PROD_TYPE = '003' AND k.RBTNUMBER <> ' ' , PS_PROD_ITEM p LEFT OUTER JOIN PS_RBT_PROD_ITEM pt ON p.PRODUCT_ID = pt.PRODUCT_ID AND pt.RBTFEATURE_FLAG = 'N' AND p.SETID = pt.SETID , PS_RF_INST_PROD_ST h WHERE i.PARENT_INST_PRODID = ' ' AND p.SETID = ( SELECT R.SETID FROM PS_SET_CNTRL_REC R WHERE R.SETCNTRLVALUE = i.SETID AND R.RECNAME = 'PROD_ITEM') AND i.PRODUCT_ID = p.PRODUCT_ID AND h.SETID = i.SETID AND h.INST_PROD_ID = i.INST_PROD_ID AND p.SERVICE = 'Y' AND h.INST_PROD_STATUS IN ('INS', 'SUS','RES','PCA')

  • Related Language Record: RBT_INSTSRV_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.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    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)

    Default Value: NEXT

    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 RBTACCTNO Character(20) VARCHAR2(20) NOT NULL Account No

    Prompt Table: RBT_ACCOUNT

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

    Prompt Table: RF_PROD_PMPT_VW

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 SITE_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: RD_COMPSITE2_VW
    Set Control Field: SETID

    10 LOCN Character(70) VARCHAR2(70) NOT NULL Physical Location
    11 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.
    12 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
    13 INSTALLED_DATE Date(10) DATE Field used for storing Installed Date of Installed product
    14 SVC_END_DATE Date(10) DATE This field is used by the Installed Product component to designate the date that the Service was terminated or suspended.
    15 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco
    16 RBT_ICCID Character(20) VARCHAR2(20) NOT NULL Integrated Circuit Card ID.