IN_SDWCPUT_CLSV

(SQL View)
 Index Back

Putaways not Complete

EOEN Context view of Putaways not complete

SELECT %subrec(EOEN_LOG_KEY, P) , P.BUSINESS_UNIT , P.STAGING_ID , P.INV_LOT_ID , P.CONTAINER_ID , P.INV_ITEM_ID , P.SERIAL_ID , P.RECEIVER_ID , P.RECV_LN_NBR , P.STAGED_NUM , P.SOURCE_BUS_UNIT , P.RECV_SHIP_SEQ_NBR , P.DISTRIB_LINE_NUM , P.DISTRIB_SEQ_NUM , '01' , B.BUSINESS_UNIT_IN , ' ' , ' ' , B.PO_ID , ' ' , A.RMA_ID , B.QTY_DS_ACCPT_SUOM , A.MOVE_STAT_INV , '1' , P.IN_SDWC_HASH_KEY , D.EOEN_STATUS , 0 , S.OPRCLASS FROM PS_IN_SDWC_PUT_CTX P , PS_EOEN_DASHBRD D , PS_RECV_LN_SHIP A , PS_RECV_LN_DISTRIB B , PS_SEC_BU_CLS S , PS_SEC_BU_CLS S1 WHERE %Join(COMMON_KEYS, IN_SDWC_PUT_CTX P, EOEN_DASHBRD D) AND D.EOEN_STATUS = '0' AND A.BUSINESS_UNIT = P.BUSINESS_UNIT AND A.RECEIVER_ID = P.RECEIVER_ID AND A.RECV_LN_NBR = P.RECV_LN_NBR AND A.RECV_SHIP_SEQ_NBR = P.RECV_SHIP_SEQ_NBR AND B.BUSINESS_UNIT = P.BUSINESS_UNIT AND B.RECEIVER_ID = P.RECEIVER_ID AND B.RECV_LN_NBR = P.RECV_LN_NBR AND B.RECV_SHIP_SEQ_NBR = P.RECV_SHIP_SEQ_NBR AND B.DISTRIB_LINE_NUM = P.DISTRIB_LINE_NUM AND A.MOVE_STAT_INV = 'P' AND P.PUTAWAY_STATE = '1' AND S.BUSINESS_UNIT = P.BUSINESS_UNIT AND S1.OPRCLASS = S.OPRCLASS AND S1.BUSINESS_UNIT = P.SOURCE_BUS_UNIT UNION ALL SELECT %subrec(EOEN_LOG_KEY, PP) , PP.BUSINESS_UNIT , PP.STAGING_ID , PP.INV_LOT_ID , PP.CONTAINER_ID , PP.INV_ITEM_ID , PP.SERIAL_ID , PP.RECEIVER_ID , PP.RECV_LN_NBR , PP.STAGED_NUM , PP.SOURCE_BUS_UNIT , PP.RECV_SHIP_SEQ_NBR , PP.DISTRIB_LINE_NUM , PP.DISTRIB_SEQ_NUM , C.TRANS_SOURCE , C.BUSINESS_UNIT , C.STAGED_STATUS , ' ' , C.PO_ID , C.PRODUCTION_ID , C.RMA_ID , C.QTY , ' ' , '2' , PP.IN_SDWC_HASH_KEY , DD.EOEN_STATUS , 0 , S.OPRCLASS FROM PS_IN_SDWC_PUT_CTX PP , PS_EOEN_DASHBRD DD , PS_STAGED_INF_INV C , PS_SEC_BU_CLS S , PS_SEC_BU_CLS S1 WHERE %Join(COMMON_KEYS, IN_SDWC_PUT_CTX PP, EOEN_DASHBRD DD) AND DD.EOEN_STATUS = '0' AND C.BUSINESS_UNIT = PP.BUSINESS_UNIT AND C.INV_LOT_ID = PP.INV_LOT_ID AND C.CONTAINER_ID = PP.CONTAINER_ID AND C.INV_ITEM_ID = PP.INV_ITEM_ID AND C.SERIAL_ID = PP.SERIAL_ID AND C.RECEIVER_ID = PP.RECEIVER_ID AND C.RECV_LN_NBR = PP.RECV_LN_NBR AND C.SEQ_NUM = PP.STAGED_NUM AND C.RECV_SHIP_SEQ_NBR = PP.RECV_SHIP_SEQ_NBR AND C.DISTRIB_LINE_NUM = PP.DISTRIB_LINE_NUM AND S.BUSINESS_UNIT = PP.BUSINESS_UNIT AND S1.OPRCLASS = S.OPRCLASS AND S1.BUSINESS_UNIT = PP.SOURCE_BUS_UNIT UNION ALL SELECT %subrec(EOEN_LOG_KEY, P3) , P3.BUSINESS_UNIT , P3.STAGING_ID , P3.INV_LOT_ID , P3.CONTAINER_ID , P3.INV_ITEM_ID , P3.SERIAL_ID , P3.RECEIVER_ID , P3.RECV_LN_NBR , P3.STAGED_NUM , P3.SOURCE_BUS_UNIT , P3.RECV_SHIP_SEQ_NBR , P3.DISTRIB_LINE_NUM , P3.DISTRIB_SEQ_NUM , E.TRANS_SOURCE , E.BUSINESS_UNIT , ' ' , E.PUTAWAY_STATUS , E.PO_ID , E.PRODUCTION_ID , E.RMA_ID , E.QTY , ' ' , '3' , P3.IN_SDWC_HASH_KEY , D3.EOEN_STATUS , 0 , S.OPRCLASS FROM PS_IN_SDWC_PUT_CTX P3 , PS_EOEN_DASHBRD D3 , PS_STAGED_ITEM_INV E , PS_SEC_BU_CLS S , PS_SEC_BU_CLS S1 WHERE %Join(COMMON_KEYS, IN_SDWC_PUT_CTX P3, EOEN_DASHBRD D3) AND D3.EOEN_STATUS = '0' AND E.BUSINESS_UNIT = P3.BUSINESS_UNIT AND E.STAGING_ID = P3.STAGING_ID AND E.INV_LOT_ID = P3.INV_LOT_ID AND E.CONTAINER_ID = P3.CONTAINER_ID AND E.INV_ITEM_ID = P3.INV_ITEM_ID AND E.SERIAL_ID = P3.SERIAL_ID AND E.RECV_LN_NBR = P3.RECV_LN_NBR AND E.STAGED_NUM = P3.STAGED_NUM AND E.RECV_SHIP_SEQ_NBR = P3.RECV_SHIP_SEQ_NBR AND E.DISTRIB_LINE_NUM = P3.DISTRIB_LINE_NUM AND E.DISTRIB_SEQ_NUM = P3.DISTRIB_SEQ_NUM AND S.BUSINESS_UNIT = P3.BUSINESS_UNIT AND S1.OPRCLASS = S.OPRCLASS AND S1.BUSINESS_UNIT = P3.SOURCE_BUS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Process Name
2 EOEN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EOEN Category
3 SEQ_NBR_EOEN Number(15,0) DECIMAL(15) NOT NULL EOEN Sequence Nbr
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

5 STAGING_ID Number(15,0) DECIMAL(15) NOT NULL Putaway Staging ID
6 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

Default Value: INSTALLATION_IN.DFLT_INV_LOT_ID

7 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID

Prompt Table: CNTR_ID_INV

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

Prompt Table: BU_ITM_INV_VW12

9 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Default Value: INSTALLATION_IN.DFLT_SERIAL_ID

10 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
11 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
12 STAGED_NUM Number(3,0) SMALLINT NOT NULL Staged Number

Default Value: 1

13 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
14 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
15 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
16 DISTRIB_SEQ_NUM Number(5,0) INTEGER NOT NULL Distribution Sequence
17 TRANS_SOURCE Character(3) VARCHAR2(3) NOT NULL Transaction Source
01=Purchasing
02=WIP Completion
03=Inventory
04=WIP Component
05=Adjustment
06=Component Kit Returns
18 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
19 STAGED_STATUS Character(3) VARCHAR2(3) NOT NULL Staged Status
01=InterUnit
02=Receipt
20 PUTAWAY_STATUS Character(1) VARCHAR2(1) NOT NULL Item Putaway Status
1=Not Assigned
2=Putaway Complete
3=In Error
21 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
22 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
23 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
24 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
25 MOVE_STAT_INV Character(1) VARCHAR2(1) NOT NULL MOVE_STAT_INV
M=Moved
N=N/A
P=Pending
26 PUTAWAY_STATE Character(1) VARCHAR2(1) NOT NULL Putaway State
1=Not Interfaced
2=Interfaced, Not Staged
3=Staged, Not Putaway
4=Putaway Complete
27 IN_SDWC_HASH_KEY Character(60) VARCHAR2(60) NOT NULL Hash
28 EOEN_STATUS Character(1) VARCHAR2(1) NOT NULL EOEN Status
0=Open
1=Closed
29 ROWNBR Number(7,0) INTEGER NOT NULL Row number
30 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class