IN_SDWC_MFG_VW

(SQL View)
 Index Back

Pending Mfg Issue Quantities

Record used by Query to populate EOEN context record.

SELECT %subrec(SF_CMP_NKEY_SBR, A) , D.PROD_STATUS , A.PEND_CONSUME_QTY , A.PEND_LOSS_QTY , A.BUSINESS_UNIT %Concat '~' %Concat A.PRODUCTION_ID %Concat '~' %Concat A.COMPONENT_ID %Concat '~' %Concat %NumToChar(A.OP_SEQUENCE) %Concat '~' %Concat A.MG_ORIG_COMP_ID FROM PS_SF_COMP_LIST A , PS_SF_PRDNID_HEADR D WHERE A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PRODUCTION_ID = D.PRODUCTION_ID AND (A.PEND_CONSUME_QTY <> 0 OR A.PEND_LOSS_QTY <> 0) AND NOT EXISTS ( SELECT B.PROD_STATUS FROM PS_IN_SDWC_MFG_CTX B , PS_EOEN_DASHBRD C WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.PRODUCTION_ID = A.PRODUCTION_ID AND B.COMPONENT_ID = A.COMPONENT_ID AND B.OP_SEQUENCE = OP_SEQUENCE AND B.MG_ORIG_COMP_ID = MG_ORIG_COMP_ID AND B.EOEN_PRCS_NAME = C.EOEN_PRCS_NAME AND B.EOEN_CATEGORY = C.EOEN_CATEGORY AND B.SEQ_NBR_EOEN = C.SEQ_NBR_EOEN AND C.EOEN_STATUS = '0')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
3 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
5 MG_ORIG_COMP_ID Character(18) VARCHAR2(18) NOT NULL original component ID
6 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
7 PROD_STATUS Character(2) VARCHAR2(2) NOT NULL Production Status
10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled
8 PEND_CONSUME_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_CONSUME
9 PEND_LOSS_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_LOSS
10 IN_SDWC_HASH_KEY Character(60) VARCHAR2(60) NOT NULL Hash