RF_IPRDVH_DP_VW

(SQL View)
 Index Back

Installed Prod Tree Dept. Node

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

SELECT DISTINCT B.SETID ,B.DEPTID ,B.DESCR ,B.DESCRSHORT ,A.SETID ,A.INST_PROD_ID ,A.BO_ID_CUST ,A.BO_ID_CONTACT ,A.PRODUCT_ID ,A.SERIAL_ID ,A.ASSETTAG ,A.SITE_ID ,A.RBTACCTID ,A.PARENT_INST_PRODID , A.TOPLVL_INSTPROD_ID , C.CFG_KIT_FLAG , E.RB_FUNCORCOM FROM PS_RF_INST_PROD A , PS_RF_DEPT_TBL_VW B , PS_PROD_ITEM C , PS_PROD_MLPB_ITEM D LEFT OUTER JOIN PS_RB_HLEV_DFN_TBL E ON E.RB_HLEV_ID = D.RB_HLEV_ID WHERE B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.SETID AND C.RECNAME = 'DEPT_TBL') AND B.DEPTID = A.DEPTID AND A.SETID = C.SETID AND A.PRODUCT_ID = C.PRODUCT_ID AND A.SETID = D.SETID AND A.PRODUCT_ID = D.PRODUCT_ID AND D.PROD_MLPB_HINS_FLG <> 'Y'

  • Related Language Record: RF_DEPT_TBL_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
    2 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    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 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 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 TOPLVL_INSTPROD_ID Character(20) VARCHAR2(20) NOT NULL Top Level Installed Product Id
    16 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit Package
    M=Multilevel Bundle Component
    N=Lightly Configured
    Y=Schema Enabled
    17 RB_FUNCORCOM Character(4) VARCHAR2(4) NOT NULL Functional/Commercial' flag used by Multilevel Component Types definition page
    COM=Commercial
    EXT=External
    FUNC=Functional