PL_PROCESS_VW

(SQL View)
 Index Back

PL Process Types Avail. Cycle

01/28/03 EGS (CN#PL880-1): Added

SELECT %Substring(A.FIELDVALUE,1,2) FROM PSXLATITEM A WHERE A.FIELDNAME = 'PLAN_PROCESS_TYPE' AND A.EFF_STATUS = 'A' AND A.FIELDVALUE <= '35'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PLAN_PROCESS_TYPE Character(2) VARCHAR2(2) NOT NULL PLAN_PROCESS_TYPE
1=Start Planning Engine
10=Load Planning Instance
11=Shutdown Planning Engine
15=Mass Maintenance
20=Initiate Material Solver
30=Extract Demand Violations
35=Post Updates
40=Initiate Feasible Solver
45=Initiate Forecast Consumption
50=Extract Pegging Information
55=Planning Report
60=Excess Stock Report
65=Capacity Report
70=Detail Resources Report
75=PO Auto Sourcing Option
80=Slow Moving Inventory Report
85=Projected Stock Out Report
90=Planning Reschedule Report
92=Planning Updates Report
94=Planning Useup Report
96=Apply Inventory Updates
98=Apply Production Updates