RBT_INSTPROD_VW

(SQL View)
 Index Back

Installed Service View

This view is used to get the installed Services for Communications.

SELECT A.SETID , A.INST_PROD_ID , B.INST_PROD_STATUS , A.PRODUCT_ID , A.CAPTURE_ID , A.LINE_NBR , A.RBTEXTERNAL_ID , A.PARENT_INST_PRODID , A.RBTNUMBER , A.RBTLINE_NBR FROM PS_RF_INST_PROD A , PS_RF_INST_PROD_ST B WHERE A.SETID = B.SETID AND A.INST_PROD_ID = B.INST_PROD_ID

# 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 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.

Prompt Table: %EDITTABLE25

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

Prompt Table: RF_PROD_PMPT_VW

5 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
6 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.
7 RBTEXTERNAL_ID Character(20) VARCHAR2(20) NOT NULL Tis field has been used for COM service management. It captures the external id which has been used in upgrade purpose.
8 PARENT_INST_PRODID Character(20) VARCHAR2(20) NOT NULL This field is used to store the installed product ID of the parent installed product

Prompt Table: %EDITTABLE30

9 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco
10 RBTLINE_NBR Number(5,0) INTEGER NOT NULL rbtline_nbr