RG_INST_PRD_VW (SQL View)	Index Back
Installed Product View Installed Product View with all fields needed for change and description field from PROD_ITEM. It contains only installed product with no 'Un Installed'.

RG_INST_PRD_VW

(SQL View)

Installed Product View

Installed Product View with all fields needed for change and description field from PROD_ITEM. It contains only installed product with no 'Un Installed'.

SELECT i.SETID , i.INST_PROD_ID , i.INST_PROD_TYPE , i.BO_ID_CUST , i.ROLE_TYPE_ID_CUST , i.BO_ID_CONTACT , i.ROLE_TYPE_ID_CNTCT , i.PRODUCT_ID , i.SERIAL_ID , i.ASSETTAG , i.SITE_ID , i.PERSON_ID , i.DEPTID , p.DESCR , w.bo_name_display FROM %Table(RF_INST_PROD) i , %Table(RF_INST_PROD_ST) s , %Table(PROD_ITEM) p , %Table(RD_PERSON_NAME) w WHERE i.SETID = s.SETID AND i.INST_PROD_ID = s.INST_PROD_ID AND s.INST_PROD_STATUS <> 'UNI' AND w.person_id = i.person_id AND w.primary_ind = 'Y' AND p.SETID = ( SELECT sc.SETID FROM %Table(SET_CNTRL_REC) sc WHERE sc.SETCNTRLVALUE = i.SETID AND sc.RECNAME = 'PROD_ITEM') AND p.PRODUCT_ID = i.PRODUCT_ID

Related Language Record: RG_INST_PRODLVW

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

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

5 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_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 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

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

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

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

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

12 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

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

14 DESCR Character(30) VARCHAR2(30) NOT NULL Description

15 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

#	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	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
4	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
5	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_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	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
8	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
9	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the Serial ID of an item or installed product
10	ASSETTAG	Character(40)	VARCHAR2(40) NOT NULL	Asset Tag
11	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.
12	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
13	DEPTID	Character(15)	VARCHAR2(15) NOT NULL	Department
14	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
15	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object