RBT_ACTPROD_VW

(SQL View)
 Index Back

View for Installed Services

Installed Products associated with the account.

SELECT A.RBTACCTID , A.INST_PROD_ID ,A.BO_ID_CUST ,A.BO_ID_CONTACT ,N.BO_NAME_DISPLAY , A.SETID , A.PRODUCT_ID , C.DESCR , H.INST_PROD_STATUS , A.CURRENCY_CD , A.RECUR_PRICE , A.PRICE , A.INSTALLED_DATE , E.RB_XLATLONGNAME , ' ' , RBT.RBT_ACCOUNT_SBIL FROM PS_RF_INST_PROD A , PS_PROD_ITEM C , PS_RBT_PROD_ITEM D , PS_RF_ISTATXLAT_VW E , PS_RF_INST_PROD_ST H ,PS_BO_NAME N , PS_RBT_PROD_ITEM RBT WHERE A.PARENT_INST_PRODID = ' ' AND A.TOPLVL_INSTPROD_ID <> A.INST_PROD_ID AND C.SETID IN ( SELECT X.SETID FROM PS_SET_CNTRL_REC X WHERE X.SETCNTRLVALUE = A.SETID AND X.RECNAME = 'PROD_ITEM') AND A.PRODUCT_ID = C.PRODUCT_ID AND D.SETID = C.SETID AND D.PRODUCT_ID = C.PRODUCT_ID AND H.SETID = A.SETID AND H.INST_PROD_ID = A.INST_PROD_ID AND D.RBTFEATURE_FLAG = 'N' AND H.INST_PROD_STATUS IN ('INS', 'SUS','PND','PSU','PRE','PCA') AND E.FIELDVALUE = H.INST_PROD_STATUS AND E.SETID = A.SETID AND E.INST_PROD_TYPE = A.INST_PROD_TYPE AND E.INST_PROD_TYPE IN ('003','002') AND ((A.BO_ID_CONTACT = N.BO_ID) OR (A.BO_ID_CONTACT = 0 AND A.BO_ID_CUST = N.BO_ID)) AND (RBT.RBT_ACCOUNT_SEL = 'N' OR RBT.RBT_ACCOUNT_SEL = ' ') AND RBT.SETID = A.SETID AND RBT.PRODUCT_ID = C.PRODUCT_ID UNION SELECT ACCT.RBTACCTID , ACCT.INST_PROD_ID ,ACCT.BO_ID_CUST ,ACCT.BO_ID_CONTACT ,N.BO_NAME_DISPLAY , A.SETID , A.PRODUCT_ID , C.DESCR , H.INST_PROD_STATUS , A.CURRENCY_CD , A.RECUR_PRICE , A.PRICE , A.INSTALLED_DATE , E.RB_XLATLONGNAME , PRD.DESCR , RBT.RBT_ACCOUNT_SBIL FROM PS_RF_INST_PROD A , PS_PROD_ITEM C , PS_RBT_PROD_ITEM D , PS_RF_ISTATXLAT_VW E , PS_RF_INST_PROD_ST H ,PS_BO_NAME N , PS_RBT_PROD_ITEM RBT , PS_RF_INST_PROD RF , PS_PROD_ITEM PRD ,PS_RF_INST_RBT ACCT WHERE C.SETID IN ( SELECT X.SETID FROM PS_SET_CNTRL_REC X WHERE X.SETCNTRLVALUE = A.SETID AND X.RECNAME = 'PROD_ITEM') AND A.PRODUCT_ID = C.PRODUCT_ID AND D.SETID = C.SETID AND D.PRODUCT_ID = C.PRODUCT_ID AND H.SETID = A.SETID AND H.INST_PROD_ID = A.INST_PROD_ID AND D.RBTFEATURE_FLAG = 'N' AND H.INST_PROD_STATUS IN ('INS', 'SUS','PND','PSU','PRE','PCA') AND E.FIELDVALUE = H.INST_PROD_STATUS AND E.SETID = A.SETID AND E.INST_PROD_TYPE = A.INST_PROD_TYPE AND E.INST_PROD_TYPE IN ('003','002') AND ((A.BO_ID_CONTACT = N.BO_ID) OR (A.BO_ID_CONTACT = 0 AND A.BO_ID_CUST = N.BO_ID)) AND RF.SETID = A.SETID AND RF.INST_PROD_ID = A.TOPLVL_INSTPROD_ID AND PRD.SETID = A.SETID AND PRD.PRODUCT_ID = RF.PRODUCT_ID AND RBT.SETID = A.SETID AND RBT.PRODUCT_ID = C.PRODUCT_ID AND RBT.RBT_ACCOUNT_SEL = 'Y' AND ACCT.SETID = A.SETID AND ACCT.INST_PROD_ID = A.INST_PROD_ID

  • Related Language Record: RBT_ACTPROD_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier

    Prompt Table: RBT_ACCOUNT
    Set Control Field: RBTACCTID

    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 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    4 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    5 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
    6 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    7 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.

    Prompt Table: RF_ISTATXLTS_VW

    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
    11 RECUR_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Recurring Price
    12 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
    13 INSTALLED_DATE Date(10) DATE Field used for storing Installed Date of Installed product
    14 RB_XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    15 TOPLVL_DESCR Character(30) VARCHAR2(30) NOT NULL Field used to store Top Level Product Description
    16 SPLIT_BILLING_FLAG Character(1) VARCHAR2(1) NOT NULL Field used for storing Split Billing check box flag

    Y/N Table Edit