RF_PROD_PHN_VW(SQL View) |
Index Back |
---|---|
Product - Item viewRetrieves 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 |