CM_TRN_ITMPR_VW

(SQL View)
 Index Back

BU / Destin BU Shared Items Vw


SELECT DISTINCT A.BUSINESS_UNIT , B.DESTIN_BU , A.INV_ITEM_ID FROM PS_BU_ITEMS_INV A , PS_CM_TRN_DBUI_VW B WHERE (A.ITM_STATUS_CURRENT = '1' OR A.ITM_STATUS_CURRENT = '3') AND A.INVENTORY_ITEM = 'Y' AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.BUSINESS_UNIT <> B.DESTIN_BU

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID