RF_IPRDVH_AC_VW (SQL View)	Index Back
Installed Prod Tree Acct Node This view is used in the creation of the Installed Product Tree. It returns distinct accounts from the Installed Product record meeting the selection criteria.

RF_IPRDVH_AC_VW

(SQL View)

Installed Prod Tree Acct Node

This view is used in the creation of the Installed Product Tree. It returns distinct accounts from the Installed Product record meeting the selection criteria.

SELECT DISTINCT A.RBTACCTID ,B.RBTACCTNAME ,A.SETID ,A.INST_PROD_ID ,A.BO_ID_CUST ,A.BO_ID_CONTACT ,A.PRODUCT_ID ,A.SERIAL_ID ,A.ASSETTAG ,A.SITE_ID ,A.DEPTID ,A.PARENT_INST_PRODID ,A.INST_PROD_TYPE , A.INSTALLED_DATE , A.RBTNUMBER , A.TOPLVL_INSTPROD_ID , C.CFG_KIT_FLAG , E.RB_FUNCORCOM FROM PS_RF_INST_PROD A , PS_RBT_ACCOUNT B , PS_PROD_ITEM C , PS_PROD_MLPB_ITEM D LEFT OUTER JOIN PS_RB_HLEV_DFN_TBL E ON E.RB_HLEV_ID = D.RB_HLEV_ID WHERE B.RBTACCTID = A.RBTACCTID AND A.SETID = C.SETID AND A.PRODUCT_ID = C.PRODUCT_ID AND A.SETID = D.SETID AND A.PRODUCT_ID = D.PRODUCT_ID AND D.PROD_MLPB_HINS_FLG <> 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RBTACCTNAME Character(30) VARCHAR2(30) NOT NULL Account Name

3 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

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

5 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

6 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

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

8 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product

9 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag

10 SITE_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

11 DEPTID Character(15) VARCHAR2(15) NOT NULL Department

12 PARENT_INST_PRODID Character(20) VARCHAR2(20) NOT NULL This field is used to store the installed product ID of the parent installed product

13 INST_PROD_TYPE Character(3) VARCHAR2(3) NOT NULL This field is used by the Installed Product component to determine the type of product that is being registered for the Customer, Site, Department or Employee. There are four allowable types: 1) Product, which designates a product assigned to an external customer; 2) Service 3) Asset, which designates a product assigned to an internal employee or department; and 4)Agreement, which designates an Installed Agreement Product (used in Order Capture integration with Agreements).
001=Asset
002=Product
003=Service
004=Agreement
005=Commitment

14 INSTALLED_DATE Date(10) DATE Field used for storing Installed Date of Installed product

15 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco

16 TOPLVL_INSTPROD_ID Character(20) VARCHAR2(20) NOT NULL Top Level Installed Product Id

17 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit Package
M=Multilevel Bundle Component
N=Lightly Configured
Y=Schema Enabled

18 RB_FUNCORCOM Character(4) VARCHAR2(4) NOT NULL Functional/Commercial' flag used by Multilevel Component Types definition page
COM=Commercial
EXT=External
FUNC=Functional

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RBTACCTID	Character(15)	VARCHAR2(15) NOT NULL	Unique service account indentifier
2	RBTACCTNAME	Character(30)	VARCHAR2(30) NOT NULL	Account Name
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
4	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
5	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
6	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
7	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
8	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the Serial ID of an item or installed product
9	ASSETTAG	Character(40)	VARCHAR2(40) NOT NULL	Asset Tag
10	SITE_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
11	DEPTID	Character(15)	VARCHAR2(15) NOT NULL	Department
12	PARENT_INST_PRODID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to store the installed product ID of the parent installed product
13	INST_PROD_TYPE	Character(3)	VARCHAR2(3) NOT NULL	This field is used by the Installed Product component to determine the type of product that is being registered for the Customer, Site, Department or Employee. There are four allowable types: 1) Product, which designates a product assigned to an external customer; 2) Service 3) Asset, which designates a product assigned to an internal employee or department; and 4)Agreement, which designates an Installed Agreement Product (used in Order Capture integration with Agreements). 001=Asset 002=Product 003=Service 004=Agreement 005=Commitment
14	INSTALLED_DATE	Date(10)	DATE	Field used for storing Installed Date of Installed product
15	RBTNUMBER	Character(15)	VARCHAR2(15) NOT NULL	Number For Telco
16	TOPLVL_INSTPROD_ID	Character(20)	VARCHAR2(20) NOT NULL	Top Level Installed Product Id
17	CFG_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Configured Kit Package M=Multilevel Bundle Component N=Lightly Configured Y=Schema Enabled
18	RB_FUNCORCOM	Character(4)	VARCHAR2(4) NOT NULL	Functional/Commercial' flag used by Multilevel Component Types definition page COM=Commercial EXT=External FUNC=Functional