PROD_PGLNCTG_VW

(SQL View)
 Index Back

Product-Prod Grp Lnk w setid


SELECT p.setid , p.product_id , pi.descr , pi.descr254 , sc.setid , p.product_group FROM PS_PROD_ITEM pi , ps_set_cntrl_rec sc , ps_prod_pgrp_lnk p WHERE pi.setid = p.setid AND pi.product_id = p.product_id AND sc.setcntrlvalue = p.setid AND sc.recname = 'PRODGP_CTLG_VW' AND p.prod_grp_type = 'CTLG'

  • Related Language Record: PROD_ITEM_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: PROD_ITEM

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    5 SETID_PROD_GRP Character(5) VARCHAR2(5) NOT NULL Product Group SetID
    6 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group

    Prompt Table: PRODGP_NGCTG_VW