MIN_ITM_ALL_VW

(SQL View)
 Index Back

All Item Prompt View

All Item Prompt View

SELECT DISTINCT INV_ITEM_ID , DESCR , SERIAL_CONTROL , LOT_CONTROL FROM PS_MASTER_ITEM_TBL WHERE ITM_STATUS_CURRENT NOT IN ('5','6','7') AND INVENTORY_ITEM = 'Y'

  • Related Language Record: ALLBU_ITM_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    N=N
    Y=Y
    4 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    N=N
    Y=Y