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

RF_IPRDVH_EM_VW

(SQL View)

Installed Prod Tree Empl Node

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

SELECT DISTINCT A.BO_ID_CONTACT ,C.BO_NAME_DISPLAY ,B.EMPLID ,A.SETID ,A.INST_PROD_ID ,A.BO_ID_CUST ,A.PRODUCT_ID ,A.SERIAL_ID ,A.ASSETTAG ,A.SITE_ID ,A.DEPTID ,A.RBTACCTID ,A.PARENT_INST_PRODID , A.TOPLVL_INSTPROD_ID , D.CFG_KIT_FLAG , F.RB_FUNCORCOM FROM PS_RF_INST_PROD A , PS_RD_PERSON B , PS_BO_NAME C , PS_PROD_ITEM D , PS_PROD_MLPB_ITEM E LEFT OUTER JOIN PS_RB_HLEV_DFN_TBL F ON F.RB_HLEV_ID = E.RB_HLEV_ID WHERE B.BO_ID = A.BO_ID_CONTACT AND C.BO_ID = B.BO_ID AND C.PRIMARY_IND = 'Y' AND A.SETID = D.SETID AND A.PRODUCT_ID = D.PRODUCT_ID AND A.SETID = E.SETID AND A.PRODUCT_ID = E.PRODUCT_ID AND E.PROD_MLPB_HINS_FLG <> 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

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

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

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 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier

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

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

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

16 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	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
2	DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This generic field stores the description and used used on various tables.
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
5	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
6	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
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	RBTACCTID	Character(15)	VARCHAR2(15) NOT NULL	Unique service account indentifier
13	PARENT_INST_PRODID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to store the installed product ID of the parent installed product
14	TOPLVL_INSTPROD_ID	Character(20)	VARCHAR2(20) NOT NULL	Top Level Installed Product Id
15	CFG_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Configured Kit Package M=Multilevel Bundle Component N=Lightly Configured Y=Schema Enabled
16	RB_FUNCORCOM	Character(4)	VARCHAR2(4) NOT NULL	Functional/Commercial' flag used by Multilevel Component Types definition page COM=Commercial EXT=External FUNC=Functional