AM_SKU_ITEM

(SQL View)
 Index Back

Software SKU Items

Software SKU is the Manufacturer Item ID (MFG_ITM_ID) on the Master Item table. View is in FS_18 along with the Master Item table.

SELECT DISTINCT A.SETID , 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 C.EFFDT = ( SELECT MAX(G.EFFDT) FROM %Table(ITM_CAT_TBL) G WHERE G.SETID = C.SETID AND G.CATEGORY_TYPE = C.CATEGORY_TYPE AND G.CATEGORY_CD = C.CATEGORY_CD AND G.CATEGORY_ID = C.CATEGORY_ID AND G.EFFDT <= %CurrentDateIn) 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 SKU Character(50) VARCHAR2(50) NOT NULL Stock Keeping Unit