SPL_SCHPRDN2_VW

(SQL View)
 Index Back

Schedule Prdn WC Grp

01/15/03 JC (CN#PL880-1): Added

SELECT A.PROBINST , A.BUSINESS_UNIT , A.PRODUCTION_ID , A.PROD_STATUS , A.INV_ITEM_ID , (B.ASSY_STARTS_QTY - B.QTY_COMP_AND_THRU - B.QTY_SCRAPPED) , E.UNIT_MEASURE_STD , B.OP_SEQUENCE , B.PLAN_START_DTTM , B.PLAN_END_DTTM , C.SF_RESRC_TYPE , C.CREW_CODE , C.MACHINE_CODE , C.TOOL_CODE , C.TOOL_QTY , B.CREWSIZE , B.MACH_RESOURCES , B.WORK_CENTER_CODE , D.WC_GROUP_CODE FROM PS_PL_PRDNID_HEADR A , PS_PL_PR_OP_LIST B , PS_PL_PR_OP_RESRC C , PS_EN_WC_GRP_DTL D , PS_PL_BU_ITEMS E WHERE A.PROBINST = B.PROBINST AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID AND B.PROBINST = C.PROBINST AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PRODUCTION_ID = C.PRODUCTION_ID AND B.OP_SEQUENCE = C.OP_SEQUENCE AND A.PROBINST = C.PROBINST AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PRODUCTION_ID = C.PRODUCTION_ID AND E.PROBINST = A.PROBINST AND E.BUSINESS_UNIT = A.BUSINESS_UNIT AND E.INV_ITEM_ID = A.INV_ITEM_ID AND A.INCL_QTY_FLG = 'Y' AND A.PROD_STATUS IN ('10','15','20','30') AND B.QTY_COMP_AND_THRU > B.EXPECTD_CMPL_QTY AND B.IGNORE_CAPACITY = 'N' AND B.WORK_CENTER_CODE = D.WORK_CENTER_CODE AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.WORK_CENTER_CODE = D.WORK_CENTER_CODE AND C.SF_RESRC_TYPE IN ('10','30','50')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
4 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
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 REMAINING_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 JNW (CN#PL900-1.0): Added
7 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
8 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
9 PLAN_START_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
10 PLAN_END_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
11 RESRC_TYPE Character(2) VARCHAR2(2) NOT NULL Resource Type
10=Primary Crew
20=Alt Crew
30=Primary Machine
40=Alt Machine
50=Primary Tool
60=Alternate Tool
12 CREW_CODE Character(10) VARCHAR2(10) NOT NULL Crew Name
13 MACHINE_CODE Character(10) VARCHAR2(10) NOT NULL Machine Code
14 TOOL_CODE Character(10) VARCHAR2(10) NOT NULL Tool ID
15 TOOL_QTY Number(12,4) DECIMAL(11,4) NOT NULL Quantity Used
16 CREWSIZE Number(7,2) DECIMAL(6,2) NOT NULL Crew Size
17 MACH_RESOURCES Number(7,2) DECIMAL(6,2) NOT NULL Machine Resources
18 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
19 WC_GROUP_CODE Character(10) VARCHAR2(10) NOT NULL F-SMERENDA-87: Planning Work center groups