PL_PLNPRD_TM_VW

(SQL View)
 Index Back

PL_PLNPRD_TM_VW

PL_PLNPRD_TM_VW

SELECT A.PROBINST , A.BUSINESS_UNIT , A.PL_SEQ_NBR , A.OP_SEQUENCE , B.TIME_TYPE , B.OP_TIME , B.OP_TIME_UNIT , B.OP_RATE , B.OP_RATE_UNIT , B.INCLUDE_SETUP FROM PS_PL_PLNPRD_OP A , PS_PL_RTG_TIME B , PS_PL_PLNPRD_HEADR C , PS_PL_BU_ITEMS D WHERE %Join(COMMON_KEYS, PL_PLNPRD_OP A, PL_RTG_TIME B) AND %Join(COMMON_KEYS, PL_PLNPRD_OP A, PL_PLNPRD_HEADR C) AND %Join(COMMON_KEYS, PL_RTG_TIME B, PL_PLNPRD_HEADR C) AND %Join(COMMON_KEYS, PL_PLNPRD_HEADR C, PL_BU_ITEMS D) AND C.INV_ITEM_ID = D.INV_ITEM_ID AND B.INV_ITEM_ID = D.REF_ROUTING_ITEM AND B.PROBINST = D.PROBINST AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.RTG_CODE = C.RTG_CODE AND B.RTG_STATE = 'PR' AND B.RTG_TYPE = 'PR'

# 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 PL_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL 01/09/02 EGS (CN#PL900-1): Added
4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
5 TIME_TYPE Character(4) VARCHAR2(4) NOT NULL Time / Resource Type
0100=Planning Labor Setup
0200=Planning Labor Fixed Run
0300=Planning Labor Run
0400=Planning Labor Post Prod
0500=Planning Machine Setup
0600=Planning Machine Fixed Run
0700=Planning Machine Run
0800=Planning Machine Post Prod
1100=Costing Labor Setup
1200=Costing Labor Fixed Run
1300=Costing Labor Run
1400=Costing Labor Post Prod
1500=Costing Machine Setup
1600=Costing Machine Fixed Run
1700=Costing Machine Run
1800=Costing Machine Post Prod
2000=Queue Time
3000=Intransit Time
6 OP_TIME Number(9,2) DECIMAL(8,2) NOT NULL Op Time
7 OP_TIME_UNIT Character(2) VARCHAR2(2) NOT NULL Time Unit
DY=Days
HR=Hours
MN=Minutes
8 OP_RATE Number(9,2) DECIMAL(8,2) NOT NULL Op Rate
9 OP_RATE_UNIT Character(2) VARCHAR2(2) NOT NULL Op Rate Unit
UD=Units/Day
UH=Units/Hour
UM=Units/Min
10 INCLUDE_SETUP Character(1) VARCHAR2(1) NOT NULL Include Setup in Lead Time
N=No
Y=Yes