DEM_CHG_INV_VW

(SQL View)
 Index Back

Inv Demand Change Msg Error

04/18/02 EGS (CN#PL900-1): Added SEQ_NBR. Removed RESPONSE_AGENT and DEM_CHG_MSG_ID.

SELECT A.BUSINESS_UNIT , SEQ_NBR , DEM_CHG_MSG_TYPE , DEM_CHG_STATUS , B.PLANNER_CD , A.INV_ITEM_ID , QTY_REQUESTED_BASE , DESTIN_BU , SCHED_DTTM , SCHED_ARRV_DTTM , PRIORITY_NBR , DEMAND_SOURCE , SOURCE_BUS_UNIT , ORDER_NO , ORDER_INT_LINE_NO , SCHED_LINE_NBR , DEMAND_LINE_NO , A.SHIP_TYPE_ID , TOLERANCE_FLG , APPROVED_FLG , FROZEN_CD , PL_FREEZE_STATUS , PL_STATUS_CD , PROCESS_INSTANCE , C.PLANNER_CD FROM PS_DEM_CHG_INF_INV A , PS_BU_ITEMS_INV B , PS_BU_ITEMS_INV C WHERE PROCESSED_FLG <> 'C' AND DEM_CHG_STATUS > '0' AND B.BUSINESS_UNIT = A.SOURCE_BUS_UNIT AND B.INV_ITEM_ID = A.INV_ITEM_ID AND C.BUSINESS_UNIT = A.DESTIN_BU AND C.INV_ITEM_ID = A.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 DEM_CHG_MSG_TYPE Character(1) VARCHAR2(1) NOT NULL Message Type
C=Cancel
N=Planned
P=Reprioritize
R=Reschedule
4 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
5 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
8 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
9 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
10 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
11 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
12 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
13 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
14 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
15 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
16 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
17 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
18 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
19 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

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

Y/N Table Edit

21 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
22 PL_FREEZE_STATUS Character(1) VARCHAR2(1) NOT NULL Planning Freeze Status
23 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
24 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
25 DEST_PLAN_CD Character(12) VARCHAR2(12) NOT NULL Destination Planner Code