RBT_ACTPROD_LVW

(SQL View)
 Index Back

View for Installed Services

Installed Products associated with the account.

SELECT A.RBTACCTID , A.INST_PROD_ID , F.LANGUAGE_CD , F.DESCR , G.RB_XLATLONGNAME FROM PS_RF_INST_PROD A , PS_PROD_ITEM C , PS_PROD_ITEM_LNG F , PS_RBT_PROD_ITEM D , PS_RF_ISTATXLAT_VW E , PS_RF_ISTATXLT_LVW G , PS_RF_INST_PROD_ST H WHERE A.PARENT_INST_PRODID = ' ' AND C.SETID = ( 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 F.SETID = C.SETID AND F.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') AND E.FIELDVALUE = H.INST_PROD_STATUS AND G.FIELDVALUE = E.FIELDVALUE AND E.SETID = A.SETID AND E.INST_PROD_TYPE = A.INST_PROD_TYPE AND G.SETID = E.SETID AND G.INST_PROD_TYPE = E.INST_PROD_TYPE AND E.INST_PROD_TYPE IN ('003','002')

  • Related Language Record for RBT_ACTPROD_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 RB_XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name