RF_PROD_ITEM_VW

(SQL View)
 Index Back

Product - Item view

Retrieves product and item combinations.

SELECT A.SETID , A.PRODUCT_ID , A.DESCR , A.INV_ITEM_ID , A.DESCR254 ,A.CFG_KIT_FLAG , C.RB_HLEV_DESCR , C.RB_TOP_LVL , C.RB_FUNCORCOM , C.RB_LINKTOFUNCT , B.OFFER_TYPE , B.BUNDLING_TYPE FROM PS_PROD_ITEM A JOIN PS_PROD_MLPB_ITEM B ON A.SETID = B.SETID AND A.PRODUCT_ID = B.PRODUCT_ID LEFT JOIN PS_RB_MLPB_STRUCT D ON A.SETID = D.SETID LEFT JOIN PS_RB_HLEV_DFN_TBL C ON B.RB_HLEV_ID = C.RB_HLEV_ID AND C.STRUCTURE_ID = D.STRUCTURE_ID

  • Related Language Record: PROD_ITEM_LNG

    • # 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 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    6 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit Package
    M=Multilevel Bundle Component
    N=Lightly Configured
    Y=Schema Enabled
    7 RB_HLEV_DESCR Character(30) VARCHAR2(30) NOT NULL Multilevel Component TYpe Description page used by Multilevel Component Types definition page
    8 RB_TOP_LVL Character(1) VARCHAR2(1) NOT NULL Top Level' flag used by Multilevel Component Types definition page
    9 RB_FUNCORCOM Character(4) VARCHAR2(4) NOT NULL Functional/Commercial' flag used by Multilevel Component Types definition page
    COM=Commercial
    EXT=External
    FUNC=Functional
    10 RB_LINKTOFUNCT Character(1) VARCHAR2(1) NOT NULL Link To Functional' flag used by Multilevel Component Types definition page
    11 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
    12 BUNDLING_TYPE Character(3) VARCHAR2(3) NOT NULL Field used for storing information about Product Bundling Type of product definition
    DED=Dedicated
    IND=Individual