MG_MSTR_ITM_LVW

(SQL View)
 Index Back

Rel Lng VW for mg_mstr_item_vw

02/05/98 Lee: Created this view for MG_MSTR_ITEM_VW.

select a.setid, a.inv_item_id, a.language_cd, a.descr from ps_master_itm_lang a, PS_MASTER_ITEM_TBL b where a.setid=b.setid and a.inv_item_id=b.inv_item_id

  • Related Language Record for MG_MSTR_ITEM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_TO Character(5) VARCHAR2(5) NOT NULL Target SetID
    2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description