WM_SERIALLOT_VW

(SQL View)
 Index Back

Work Management Serial/Lot vw

Work Management Serial/Lot View

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.DT_TIMESTAMP , A.SEQ_NBR , B.BUSINESS_UNIT , B.WO_ID , B.WO_TASK_ID , B.RES_LN_NBR , A.DEMAND_LINE_NO , A.QTY , A.INV_LOT_ID , A.SERIAL_ID , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.CONTAINER_ID FROM PS_TRANSACTION_INV A , PS_WM_WO_SCHED_MAT B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT_IN AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.SOURCE_BUS_UNIT = B.BUSINESS_UNIT AND A.ORDER_NO = B.WO_ID AND A.ORDER_INT_LINE_NO = B.WO_TASK_ID AND A.SCHED_LINE_NBR = B.RES_LN_NBR AND A.TRANSACTION_GROUP = '231'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITM_INV_VW

3 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
6 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
7 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
8 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
9 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
10 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
11 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
12 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
13 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
14 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
15 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
16 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
17 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
18 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID