BUSINESS_UNITINV_CART_IDINV_ITEM_IDPrompt Table: INV_ITEM_GROUP
Prompt Table: INV_ITEM_FAM
CRT_ITEM_USG_VW(SQL View) |
Index Back |
|---|---|
Cart Usage Tracked Item ViewThis view is used as a prompt table for the item ID field on the Item Usage Label run contrl panel when a "Par Location" is selected. |
| select distinct A.BUSINESS_UNIT, A.INV_CART_ID, A.INV_ITEM_ID, D.DESCR, D.INV_ITEM_GROUP, D.INV_PROD_FAM_CD from PS_CART_TEMPL_INV A, PS_CART_ATTRIB_INV B, PS_SET_CNTRL_REC C, PS_MASTER_ITEM_TBL D where B.BUSINESS_UNIT = A.BUSINESS_UNIT and B.INV_CART_ID = A.INV_CART_ID and C.SETCNTRLVALUE = B.BUSINESS_UNIT and C.RECNAME = 'MASTER_ITEM_TBL' and D.SETID = C.SETID and D.INV_ITEM_ID = A.INV_ITEM_ID and (A.USG_TRCKNG_METHOD = '02' or A.USG_TRCKNG_METHOD = '03') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_CART_ID |
Character(15) | VARCHAR2(15) NOT NULL | Par Location ID |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 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 |