CM_OH_SNP2_VW1

(SQL View)
 Index Back

Onhand Intransit Qty View

07/03/02 - B1280/RES102536/INC503212002

SELECT A.PROCESS_INSTANCE , A.BUSINESS_UNIT , B.SOURCE_BUS_UNIT , B.DESTIN_BU , A.CM_BOOK , A.INV_ITEM_ID , A.INV_LOT_ID , A.SERIAL_ID , B.INTERUNIT_ID , B.INTERUNIT_LINE , SUM(A.CM_ONHAND_QTY) , SUM(A.MONETARY_AMOUNT) FROM PS_CM_OH_SNP2_TBL A , PS_CM_INTRANSIT B WHERE INTRANSIT_FLAG = 'Y' AND A.BUSINESS_UNIT = B.OWNERSHIP_BU AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.DT_TIMESTAMP = B.DT_TIMESTAMP AND A.SEQ_NBR = B.SEQ_NBR AND A.SOURCE_BUS_UNIT =B.BUSINESS_UNIT GROUP BY A.PROCESS_INSTANCE , A.BUSINESS_UNIT , B.SOURCE_BUS_UNIT, B.DESTIN_BU,A.CM_BOOK , A.INV_ITEM_ID , A.INV_LOT_ID, A.SERIAL_ID , INTERUNIT_ID, INTERUNIT_LINE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
4 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
5 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
8 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
9 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
10 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
11 CM_ONHAND_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/30/99 RML Changed from "onhand" to "on hand"
12 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.