RF_IPRDVH_ST_VW

(SQL View)
 Index Back

Installed Prod Tree Site Node

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

SELECT DISTINCT B.SETID ,B.SITE_ID ,C.BO_NAME ,B.ADDRESS80 ,A.SETID ,A.INST_PROD_ID ,A.BO_ID_CUST ,A.BO_ID_CONTACT ,A.PRODUCT_ID ,A.SERIAL_ID ,A.ASSETTAG ,A.DEPTID ,A.RBTACCTID ,A.PARENT_INST_PRODID , A.INST_PROD_TYPE ,A.INSTALLED_DATE ,A.RBTNUMBER , A.TOPLVL_INSTPROD_ID , D.CFG_KIT_FLAG , F.RB_FUNCORCOM FROM PS_RF_INST_PROD A , PS_RF_SO_SADDR_VW2 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.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.SETID AND D.RECNAME = 'RD_SITE') AND B.SITE_ID = A.SITE_ID 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 SETID_SITE Character(5) VARCHAR2(5) NOT NULL SetID of Site
2 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.
3 BO_NAME_1 Character(50) VARCHAR2(50) NOT NULL BO Name 1
4 ADDRESS80 Character(80) VARCHAR2(80) NOT NULL Address
5 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
6 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
7 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
8 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
10 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product
11 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag
12 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
13 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier
14 PARENT_INST_PRODID Character(20) VARCHAR2(20) NOT NULL This field is used to store the installed product ID of the parent installed product
15 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
16 INSTALLED_DATE Date(10) DATE Field used for storing Installed Date of Installed product
17 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco
18 TOPLVL_INSTPROD_ID Character(20) VARCHAR2(20) NOT NULL Top Level Installed Product Id
19 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit Package
M=Multilevel Bundle Component
N=Lightly Configured
Y=Schema Enabled
20 RB_FUNCORCOM Character(4) VARCHAR2(4) NOT NULL Functional/Commercial' flag used by Multilevel Component Types definition page
COM=Commercial
EXT=External
FUNC=Functional