SETIDDefault Value: OPR_DEF_TBL_FS.SETID
INV_ITEM_IDEFFDTLANGUAGE_CDINV_IMLO_LNG_VW(SQL View) |
Index Back |
|---|---|
Lot Ctrl Items Rellang Viewuse by INV_ITEM_LOT_VW |
| SELECT m.setid , m.inv_item_id , k.effdt , m.language_cd , m.descr FROM PS_MASTER_ITEM_TBL mi , ps_inv_items k , ps_master_itm_lang m WHERE m.setid = k.setid AND m.inv_item_id = k.inv_item_id AND mi.setid = k.setid AND mi.inv_item_id = k.inv_item_id AND mi.itm_status_current <> '5' AND mi.itm_status_current <> '6' AND mi.itm_status_current <> '7' AND mi.inventory_item = 'Y' AND mi.lot_control = 'Y' |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |