DEM_CHG_PLNR_VW

(SQL View)
Index Back

Inv Demand Change I/F

1/3/02 JNW (CN#PL900-1): added field pl_tr_status 01/09/02 EGS (CN#PL900-1): Added PROBSINST AND PL_SEQ_NBR. 3/20/02 JNW (CN#PL900-1): Added INTERUNIT_FLG 04/17/02 EGS (CN#PL900-1): Removed PLANNER_CD, DEM_CHG_MSG_ID, PLANNING_VERSION, RESPONSE_AGENT, EP_GROUP_CODE, RPS_TRANS_ID, DEST_PLAN_CD, PL_TR_STATUS and PROCESS_FLG. Changed keys to BUSINESS_UNIT and SEQ_NBR. Added PL_PLAN_STATUS and PL_PLAN_STATUS. 08/28/02 EGS (CN#PL880-1): Added ORIG_SCHED_DATE, ORIG_SCHED_TIME, SCHED_ARRV_ORIG. 06/26/04 PWF Change reference from SCHED_LINE_NO to SCHED_LINE_NBR

SELECT A.BUSINESS_UNIT , A.SEQ_NBR , A.PLANNING_TIMESTAMP , A.DEM_CHG_MSG_TYPE , A.PROBINST , A.PL_SEQ_NBR , A.DEM_CHG_STATUS , A.INV_ITEM_ID , A.QTY_REQUESTED_BASE , A.DESTIN_BU , C.PLANNER_CD , A.SCHED_dttm , A.SCHED_ARRV_DTTM , A.ORIG_SCHED_DTTM , A.SCHED_ARRV_ORIG , A.PRIORITY_NBR , A.DEMAND_SOURCE , A.SOURCE_BUS_UNIT , B.PLANNER_CD , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.DEMAND_LINE_NO , A.SHIP_TYPE_ID , A.TOLERANCE_FLG , A.APPROVED_FLG , A.FROZEN_CD , A.INTERUNIT_FLG , A.PL_FREEZE_STATUS , A.PL_STATUS_CD , A.PL_PLAN_STATUS , A.PROCESS_INSTANCE , A.PROCESSED_FLG , A.CONFIG_CODE , A.PEG_STATUS , A.SUP_PEG_STATUS FROM PS_DEM_CHG_INF_INV A , PS_PL_ITEM_ATTRIB B , PS_PL_ITEM_ATTRIB C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.DESTIN_BU = C.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.INV_ITEM_ID = C.INV_ITEM_ID

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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUIN_NONVW

2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
3 PLANNING_TIMESTAMP DateTime(26) TIMESTAMP Planning Date and Time
4 DEM_CHG_MSG_TYPE Character(1) VARCHAR2(1) NOT NULL Message Type
C=Cancel
N=Planned
P=Reprioritize
R=Reschedule
5 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
6 PL_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL 01/09/02 EGS (CN#PL900-1): Added
7 DEM_CHG_STATUS Character(1) VARCHAR2(1) NOT NULL Status
0=Not Processed
1=Demand Line Not Found
2=Picklist Printed
3=In Shipping
4=Item not Approved
5=BU Item not defined
6=SetID's different
7=No Interunit Ownership
8=Intercompany setup invalid
9=Processed
8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
9 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
10 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
11 DEST_PLAN_CD Character(12) VARCHAR2(12) NOT NULL Destination Planner Code

Prompt Table: PLANNER_TBL

12 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
13 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
14 ORIG_SCHED_DTTM DateTime(26) TIMESTAMP Original Schedule Date/Time
15 SCHED_ARRV_ORIG DateTime(26) TIMESTAMP Original Sch Arrival
16 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority

Default Value: 999

17 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
18 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
19 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code

Prompt Table: PLANNER_TBL

20 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
21 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
22 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
23 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
24 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
25 TOLERANCE_FLG Character(1) VARCHAR2(1) NOT NULL jnw changed long description for planning phoenix - commit plan 10/18/02 JC (CN#PL880-1): Added TOLERANCE label

Y/N Table Edit

Default Value: N

26 APPROVED_FLG Character(1) VARCHAR2(1) NOT NULL Approved by Auditor
D=Denied
N=Not Approved
Y=Approved

Y/N Table Edit

Default Value: N

27 FROZEN_CD Character(1) VARCHAR2(1) NOT NULL Frozen code
1=Change from unfrozen to frozen
2=Change from frozen to unfrozen
3=No Change
28 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes

Y/N Table Edit

29 PL_FREEZE_STATUS Character(1) VARCHAR2(1) NOT NULL Planning Freeze Status

Y/N Table Edit

30 PL_STATUS_CD Character(2) VARCHAR2(2) NOT NULL 08/07/98 SCC CN#APRD-R-SCHEW-8L1TB: Change description for value 10 'Before Planning Time Fence' to 'Expedite'
10=Expedite
20=Accepted Horizon
30=After Cutoff Fence
40=No Time Fence Defined
99=Error/Exception

Default Value: 40

31 PL_PLAN_STATUS Character(2) VARCHAR2(2) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
05=Planned
15=Firmed
90=Canceled
32 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
33 PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Plan Processed Flag
C=Complete
E=Errors
N=Initialize
P=In Process
34 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
35 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
36 SUP_PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Unpegged