CNT_DST_BU_LANG

(SQL View)
 Index Back

BU Language View for Markup

PO002, BU prompt language view on markup detail page for Manufacturer Contract.

SELECT d.SETID , d.CNTRCT_ID , a.business_unit , c.language_cd , c.descr FROM PS_BUS_UNIT_TBL_PM a , ps_bus_unit_tbl_fs b , ps_bus_unit_lang c , ps_cnt_ctrl_type d WHERE a.business_unit = b.business_unit AND a.business_unit = c.business_unit AND a.business_unit = d.business_unit AND d.CONTROL_TYPE = 'BU'

  • Related Language Record for CNT_DST_BU_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CNTRCT_ID_DST Character(25) VARCHAR2(25) NOT NULL Contract ID To
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description