INV_ITM_LOT_VW2

(SQL View)
 Index Back

Lot Ctrl Items View SETID cntl


SELECT m.setid , m.inv_item_id , k.effdt , m.descr , m.serial_control , m.lot_control FROM PS_MASTER_ITEM_TBL m , ps_inv_items k WHERE m.setid = k.setid AND m.inv_item_id = k.inv_item_id AND m.itm_status_current IN ('1','2','3','4') AND m.inventory_item = 'Y' AND m.lot_control = 'Y'

  • Related Language Record: INV_IMLO_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    3 EFFDT Date(10) DATE Effective Date
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    N=N
    Y=Y
    6 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    N=N
    Y=Y