WM_INV_BUNON_VW

(SQL View)
 Index Back

WM Inv Item BU Non-Applic View

WM Inventory Item Bus Unit Non-Applicable View

SELECT A.SETID , A.ITM_SETID , B.INV_ITEM_ID , C.BUSINESS_UNIT , C.BUSINESS_UNIT_IN , 'N' FROM PS_WM_TT_ITMSET_VW A , PS_WM_WO_TTMITM_VW B , PS_BUS_UNIT_TBL_WM C WHERE B.ITM_SETID = A.ITM_SETID AND C.BUSINESS_UNIT IN ( SELECT DISTINCT I.SETCNTRLVALUE FROM PS_SET_CNTRL_REC I WHERE I.REC_GROUP_ID = 'WM_01' AND I.SETID = A.SETID) AND NOT EXISTS ( SELECT 'X' FROM PS_WM_INV_ITM_VW J WHERE J.BUSINESS_UNIT = C.BUSINESS_UNIT AND J.INV_ITEM_ID = B.INV_ITEM_ID AND J.BUSINESS_UNIT_IN = C.BUSINESS_UNIT_IN)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
6 BU_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Bus Unit Applicability