RBC_PROD_GRP_LG

(SQL View)
Index Back

Product Group View

This record stores the valid Product Group Codes to be used for Pricing, Reporting, Accounting, Transit and more.

SELECT DISTINCT A.PRODUCT_GROUP ,B.LANGUAGE_CD , B.DESCR FROM PS_PROD_GROUP_TBL A , PS_PROD_GROUP_LNG B WHERE A.PRODUCT_GROUP = B.PRODUCT_GROUP

  • Related Language Record for RBC_PROD_GRP_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description