RF_IPRDVH_CC_VW

(SQL View)
Index Back

Installed Prod Tree Cust Node

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

SELECT DISTINCT A.BO_ID_CUST ,B.SETID ,B.CUST_ID ,C.BO_NAME_DISPLAY ,A.SETID ,A.INST_PROD_ID ,A.BO_ID_CONTACT ,G.BO_NAME_DISPLAY ,A.PRODUCT_ID ,A.SERIAL_ID ,A.ASSETTAG ,A.SITE_ID ,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 LEFT OUTER JOIN PS_BO_NAME G ON G.BO_ID = A.BO_ID_CONTACT , PS_BC 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_CUST 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_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
2 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID
3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID
4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
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_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
8 BO_NAME_DISPLAY_1 Character(80) VARCHAR2(80) NOT NULL This field represents the Display Name for a business object
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 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.
13 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
14 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier
15 PARENT_INST_PRODID Character(20) VARCHAR2(20) NOT NULL This field is used to store the installed product ID of the parent installed product
16 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
17 INSTALLED_DATE Date(10) DATE Field used for storing Installed Date of Installed product
18 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco
19 TOPLVL_INSTPROD_ID Character(20) VARCHAR2(20) NOT NULL Top Level Installed Product Id
20 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit Package
M=Multilevel Bundle Component
N=Lightly Configured
Y=Schema Enabled
21 RB_FUNCORCOM Character(4) VARCHAR2(4) NOT NULL Functional/Commercial' flag used by Multilevel Component Types definition page
COM=Commercial
EXT=External
FUNC=Functional