RF_IPRD_VH_VW

(SQL View)
 Index Back

Installed Prod Tree IP Node

This view is used in the creation of the Installed Product Tree. It returns installed products meeting the selection criteria.

SELECT DISTINCT A.SETID ,A.INST_PROD_ID ,A.INST_PROD_TYPE ,C.INST_PROD_STATUS ,A.BO_ID_CUST ,A.BO_ID_CONTACT ,A.PRODUCT_ID ,A.SERIAL_ID ,A.ASSETTAG ,A.SITE_ID ,A.DEPTID ,A.RBTACCTID ,A.PARENT_INST_PRODID ,B.SERVICE ,B.PRODUCT_KIT_FLAG ,B.DESCR ,B.DESCR254 ,A.INSTALLED_DATE ,A.RBTNUMBER , A.TOPLVL_INSTPROD_ID , B.CFG_KIT_FLAG , D.PROD_MLPB_HINS_FLG , D.RB_HLEV_ID , E.RB_TOP_LVL , E.RB_FUNCORCOM , D.OFFER_TYPE , E.RB_LINKTOFUNCT FROM PS_RF_INST_PROD A JOIN PS_PROD_ITEM B ON A.SETID = B.SETID AND A.PRODUCT_ID = B.PRODUCT_ID JOIN PS_RF_INST_PROD_ST C ON A.SETID = C.SETID AND A.INST_PROD_ID = C.INST_PROD_ID JOIN PS_PROD_MLPB_ITEM D ON B.SETID = D.SETID AND B.PRODUCT_ID = D.PRODUCT_ID LEFT JOIN PS_RB_MLPB_STRUCT F ON B.SETID = F.SETID LEFT JOIN PS_RB_HLEV_DFN_TBL E ON E.STRUCTURE_ID = F.STRUCTURE_ID AND E.RB_HLEV_ID = D.RB_HLEV_ID

  • Related Language Record: RF_IPRD_VH_LVW

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

    Prompt Table: SP_SETID_NONVW

    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 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.
    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 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 SERVICE Character(1) VARCHAR2(1) NOT NULL Service Flag
    15 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit Flag
    16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    17 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    18 INSTALLED_DATE Date(10) DATE Field used for storing Installed Date of Installed product
    19 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco
    20 TOPLVL_INSTPROD_ID Character(20) VARCHAR2(20) NOT NULL Top Level Installed Product Id
    21 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit Package
    M=Multilevel Bundle Component
    N=Lightly Configured
    Y=Schema Enabled
    22 PROD_MLPB_HINS_FLG Character(1) VARCHAR2(1) NOT NULL Hide in Installed Hierarchy' flag used bu Product Definition page for defining new Multilevel Product Bundles
    23 RB_HLEV_ID Character(20) VARCHAR2(20) NOT NULL Field used for storing multilevel structure level id information
    24 RB_TOP_LVL Character(1) VARCHAR2(1) NOT NULL Top Level' flag used by Multilevel Component Types definition page
    25 RB_FUNCORCOM Character(4) VARCHAR2(4) NOT NULL Functional/Commercial' flag used by Multilevel Component Types definition page
    COM=Commercial
    EXT=External
    FUNC=Functional
    26 OFFER_TYPE Character(3) VARCHAR2(3) NOT NULL New Field added to PROD_MLPB_ITEM table to store information about offer type for given product
    GRP=Group
    SHR=Shared
    27 RB_LINKTOFUNCT Character(1) VARCHAR2(1) NOT NULL Link To Functional' flag used by Multilevel Component Types definition page