GS1_ITM_SLSS_VW(SQL View) |
Index Back |
|---|---|
Master Item Stockless ViewThis table selects items that are approved and can be supplied as stockless. |
| SELECT DISTINCT m.setid , m.inv_item_id , k.effdt , m.descr , m.inv_item_group , m.inv_prod_fam_cd ,D.ITM_ID_VNDR ,G.CATEGORY_CD ,E.MFG_ID ,E.MFG_ITM_ID , F.UPN_ID , M.SERIAL_CONTROL , M.LOT_CONTROL FROM PS_MASTER_ITEM_TBL M LEFT OUTER JOIN PS_ITM_VENDOR D ON (M.SETID =D.SETID AND M.INV_ITEM_ID = D.INV_ITEM_ID) LEFT OUTER JOIN PS_ITM_CAT_VW G ON (M.SETID =G.SETID AND M.CATEGORY_ID = G.CATEGORY_ID ) LEFT OUTER JOIN PS_ITEM_MFG E ON (M.SETID = E.SETID AND M.INV_ITEM_ID = E.INV_ITEM_ID ) LEFT OUTER JOIN PS_ITEM_MFG_UPN_FS F ON (E.SETID = F.SETID AND E.INV_ITEM_ID = F.INV_ITEM_ID AND E.MFG_ID =F.MFG_ID AND E.MFG_ITM_ID = F.MFG_ITM_ID AND F.UPN_TYPE_CD = 'GTIN') , ps_inv_items k , ps_purch_item_attr p WHERE m.setid = k.setid AND k.setid = p.setid AND m.inv_item_id = k.inv_item_id AND k.inv_item_id = p.inv_item_id AND m.itm_status_current <> '5' AND m.itm_status_current <> '6' AND m.itm_status_current <> '7' AND p.stockless_flg = '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 Prompt Table: SP_SETID_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MST_ITM_PRPT_VW |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL |
Item Group
Prompt Table: INV_ITEM_GROUP |
| 6 | INV_PROD_FAM_CD | Character(10) | VARCHAR2(10) NOT NULL |
Family
Prompt Table: INV_ITEM_FAM |
| 7 | ITM_ID_VNDR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |
| 8 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL | Category Code |
| 9 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table: MFG_VW |
| 10 | MFG_ITM_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer's Item ID
Prompt Table: ITEM_MFG_ID_VW |
| 11 | UPN_ID | Character(20) | VARCHAR2(20) NOT NULL |
Universal Product Number
Prompt Table: GS1_IN_UPN_VW |
| 12 | SERIAL_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Serial Control
N=N Y=Y |
| 13 | LOT_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Lot Control
N=N Y=Y |