RBT_INST_PND_VW

(SQL View)
 Index Back

Installed Services View

View to retrieve all the Installed Services that have no associated customer value, are not service features, and which are in Pending Status

SELECT D.BO_ID , I.INST_PROD_ID , I.PRODUCT_ID , P.DESCR , H.INST_PROD_STATUS , I.LOCN FROM PS_RF_INST_PROD I , PS_PROD_ITEM P , PS_RBT_PROD_ITEM PT , PS_RBT_PROD_ACTION PA , 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 P.SERVICE = 'Y' AND PT.RBTFEATURE_FLAG = 'N' AND P.SETID = PA.SETID AND P.PRODUCT_ID = PA.PRODUCT_ID AND PA.RBTACTION_ID='2' 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

  • Related Language Record: RBT_INSTPND_LVW

    • # 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 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

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

    Prompt Table: RF_PROD_PMPT_VW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.
    6 LOCN Character(70) VARCHAR2(70) NOT NULL Physical Location