RBT_PER_SERV_VW

(SQL View)
 Index Back

My Services

SELECT INST.SETID ,INST.INST_PROD_ID ,TEL.RECUR_PRICE ,PROD.DESCR ,ACCT.RBTACCTNO ,INST.PRODUCT_ID ,INST.BO_ID_CUST ,INST.BO_ID_CONTACT ,INST.ROLE_TYPE_ID_CUST ,INST.ROLE_TYPE_ID_CNTCT ,ACCT.RBTACCTID ,INST.INST_PROD_STATUS FROM PS_RF_INST_PROD INST ,PS_RFTINST_PROD TEL ,PS_PROD_ITEM PROD ,PS_RBT_PER_ACCT_VW ACCT ,PS_RBT_PROD_ITEM TELPROD WHERE INST.INST_PROD_ID=TEL.INST_PROD_ID AND INST.SETID=TEL.SETID AND INST.PRODUCT_ID=PROD.PRODUCT_ID AND INST.SETID=PROD.SETID AND TEL.RBTACCTID=ACCT.RBTACCTID AND PROD.SERVICE='Y' AND PROD.PRODUCT_ID=TELPROD.PRODUCT_ID AND PROD.SETID=TELPROD.SETID AND TELPROD.RBTFEATURE_FLAG='N' AND INST.INST_PROD_STATUS <> 'DIS' AND INST.PARENT_INST_PRODID=' '

SELECT inst.setid , inst.inst_prod_id , inst.recur_price , prod.descr , acct.rbtacctno , inst.product_id , inst.bo_id_cust , inst.bo_id_contact , inst.role_type_id_cust , inst.role_type_id_cntct , acct.rbtacctid , h.inst_prod_status , rbt.rbt_account_sbil FROM PS_RF_INST_PROD inst , ps_prod_item prod , ps_rbt_per_acct_vw acct , ps_rbt_prod_item telprod , PS_RF_INST_PROD_st h , ps_rbt_prod_item rbt WHERE prod.setid = ( SELECT x.setid FROM ps_set_cntrl_rec x WHERE x.setcntrlvalue = inst.setid AND x.recname = 'PROD_ITEM') AND inst.product_id = prod.product_id AND (acct.rbtacctid = inst.rbtacctid OR acct.rbtacctid IN ( SELECT b.rbtacctid FROM ps_rf_inst_rbt b , ps_rbt_prod_dtl dfn WHERE b.setid = inst.setid AND b.inst_prod_id = inst.inst_prod_id AND dfn.setid = b.setid AND dfn.product_id = inst.product_id AND dfn.primary_flag = 'Y')) AND h.setid = inst.setid AND h.inst_prod_id = inst.inst_prod_id AND (prod.service = 'Y' OR prod.CFG_KIT_FLAG='M') AND prod.product_id = telprod.product_id AND prod.setid = telprod.setid AND telprod.rbtfeature_flag = 'N' AND h.inst_prod_status <> 'DIS' AND rbt.setid = inst.setid AND rbt.product_id = inst.product_id

  • Related Language Record: RBT_PERSERV_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 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)

    Default Value: NEXT

    3 RECUR_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Recurring Price
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 RBTACCTNO Character(20) VARCHAR2(20) NOT NULL Account No

    Prompt Table: RBT_ACCOUNT

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

    Prompt Table: RF_PROD_PMPT_VW

    7 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    8 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    9 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    10 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    11 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier
    12 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.

    Prompt Table: RF_ISTATXLTS_VW

    13 RBT_ACCOUNT_SBIL Character(1) VARCHAR2(1) NOT NULL Field used for storing Split Billing flag value