CM_ITEM_MAST_VW

(SQL View)
Index Back

SELECT C.BUSINESS_UNIT , A.SETID , A.INV_ITEM_ID , A.INV_ITEM_GROUP , A.CONSIGNED_FLAG FROM PS_MASTER_ITEM_TBL A , PS_SET_CNTRL_REC B , PS_BU_ITEMS_INV C WHERE B.SETCNTRLVALUE = C.BUSINESS_UNIT AND B.RECNAME = 'MASTER_ITEM_TBL' AND A.SETID = B.SETID AND A.INV_ITEM_ID = C.INV_ITEM_ID AND B.RECNAME = 'MASTER_ITEM_TBL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
5 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag