RF_PROD_PHN_VW

(SQL View)
Index Back

Product - Item view

Retrieves Installed product, Billing Account and component type information.

SELECT A.SETID , A.INST_PROD_ID , A.PARENT_INST_PRODID , A.PRODUCT_ID , C.RB_HLEV_ID , A.RBTACCTID , A.RBTNUMBER FROM PS_RF_INST_PROD A , PS_RF_INST_PROD_ST D , PS_PROD_ITEM B LEFT JOIN PS_PROD_MLPB_ITEM C ON (C.SETID = B.SETID AND C.PRODUCT_ID = B.PRODUCT_ID) WHERE A.SETID = B.SETID AND A.PRODUCT_ID = B.PRODUCT_ID AND A.SETID = D.SETID AND A.INST_PROD_ID = D.INST_PROD_ID AND D.INST_PROD_STATUS NOT IN ('PDI','DIS')

# 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 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
3 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

4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
5 RB_HLEV_ID Character(20) VARCHAR2(20) NOT NULL Field used for storing multilevel structure level id information
6 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier
7 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco