CM_TRN_GRPPR_VW

(SQL View)
 Index Back

BU / Destin BU Shared Items Vw


SELECT DISTINCT SETID , BUSINESS_UNIT , DESTIN_BU , INV_ITEM_GROUP FROM PS_MASTER_ITEM_TBL B , PS_CM_TRN_ITMPR_VW A WHERE B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'MASTER_ITEM_TBL') AND B.INVENTORY_ITEM = 'Y' AND B.ITM_STATUS_CURRENT IN ('1', '3') AND A.INV_ITEM_ID = B.INV_ITEM_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
4 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group