IT_SKU_ITEM_ALL

(SQL View)
 Index Back

Software SKU Items

Software SKU is the Manufacturer Item ID (MFG_ITM_ID) on the Master Item table. This is a view of ALL IDs regardless of SetId.

SELECT A.MFG_ITM_ID FROM %Table(ITEM_MFG) A , %Table(MASTER_ITEM_TBL) B , %Table(ITM_CAT_TBL) C , %Table(PROFILE_TBL) D WHERE A.SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.MFG_ITM_ID <> ' ' AND C.SETID = B.SETID AND C.CATEGORY_ID = B.CATEGORY_ID AND D.SETID = ( SELECT F.SETID FROM %Table(REC_GROUP_REC) E , %Table(SET_CNTRL_GROUP) F WHERE E.RECNAME = 'PROFILE_TBL' AND F.SETCNTRLVALUE = C.SETID AND F.REC_GROUP_ID = E.REC_GROUP_ID) AND D.PROFILE_ID = C.PROFILE_ID AND D.ASSET_TYPE = '020'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SKU Character(50) VARCHAR2(50) NOT NULL Stock Keeping Unit