ALLBU_ITM_LG_VW

(SQL View)
 Index Back

All BU Item Language View

All BU Item Language View

SELECT DISTINCT ML.INV_ITEM_ID , ML.LANGUAGE_CD , ML.DESCR FROM PS_MASTER_ITEM_TBL MI ,PS_MASTER_ITM_LANG ML WHERE MI.SETID = ML.SETID AND MI.INV_ITEM_ID = ML.INV_ITEM_ID AND MI.ITM_STATUS_CURRENT NOT IN ('5','6','7') AND MI.INVENTORY_ITEM = 'Y'

  • Related Language Record for ALLBU_ITEM_K_VW MIN_ITM_ALL_VW

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