PROD_IBU_LVW

(SQL View)
Index Back

SELECT sc.setid , i.business_unit , f.language_cd , f.descr FROM ps_set_cntrl_rec sc , PS_BUS_UNIT_TBL_IN i , ps_bus_unit_lang f WHERE sc.recname = 'PROD_ITEM' AND i.business_unit = sc.setcntrlvalue AND i.business_unit = f.business_unit

  • Related Language Record for PROD_IBU_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description