APS_WO_PT_VW

(SQL View)
Index Back

APS Integ Work Ord Comp View


SELECT P.BUSINESS_UNIT , P.INV_ITEM_ID , P.PRODUCTION_ID , C.OP_SEQUENCE , 0 AS BOM_CODE , 0 AS RTG_CODE , C.COMPONENT_ID , C.CURR_SCHED_QTY , C.YIELD_QTY , C.SF_QTY_PER , C.QTY_CODE , I.ITM_SETID , P.NEW_START_DATE ,P.NEW_END_DATE , P.PROD_STATUS ,P.PRODUCTION_TYPE ,L.WORK_CENTER_CODE , I.UNIT_MEASURE_STD FROM PS_SF_PRDNID_HEADR P , PS_SF_COMP_LIST C , PS_SF_OP_LIST L , PS_APS_ITEM_BU_VW I WHERE P.PROD_STATUS IN('15','20','30') AND I.INV_ITEM_ID = P.INV_ITEM_ID AND I.BUSINESS_UNIT = P.BUSINESS_UNIT AND C.BUSINESS_UNIT = P.BUSINESS_UNIT AND C.PRODUCTION_ID = P.PRODUCTION_ID AND C.BUSINESS_UNIT = L.BUSINESS_UNIT AND C.PRODUCTION_ID = L.PRODUCTION_ID AND C.OP_SEQUENCE = L.OP_SEQUENCE AND EXISTS ( SELECT 'X' FROM PS_APS_ITEM_BU_VW II WHERE II.INV_ITEM_ID = C.COMPONENT_ID AND II.BUSINESS_UNIT = C.BUSINESS_UNIT )

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

Prompt Table: SP_BUMGOP_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
5 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
6 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
7 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

Prompt Table: %EDITTABLE

8 CURR_SCHED_QTY Number(12,4) DECIMAL(11,4) NOT NULL 07/28/99 SCC CN#SF800-9.0: Added label id TO_CURR_SCHED
9 YIELD_QTY Number(12,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY
10 SF_QTY_PER Number(16,10) DECIMAL(15,10) NOT NULL 07/06/99 SCC CN# SF800-9.0: Added label Quantity
11 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order

Default Value: ASY

12 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
13 NEW_START_DATE Date(10) DATE Start Date
14 NEW_END_DATE Date(10) DATE Due Date
15 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
16 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown
17 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
18 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure