RBT_ACC_INST_VW (SQL View)	Index Back
COM Account Service Phone View for to find the parent installed product for a prepaid account

RBT_ACC_INST_VW

(SQL View)

COM Account Service Phone

View for to find the parent installed product for a prepaid account

SELECT A.SETID , A.RBTACCTID , B.INST_PROD_ID FROM PS_RBT_ACCOUNT A , PS_RF_INST_PROD B WHERE A.SETID = B.SETID AND A.RBTACCTID = B.RBTACCTID AND B.PARENT_INST_PRODID = ' '

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

2 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier

3 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)

#	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.
2	RBTACCTID	Character(15)	VARCHAR2(15) NOT NULL	Unique service account indentifier
3	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)