PL_IN_EXCPT_VW

(SQL View)
Index Back

PL/IN Change Exceptions

03/13/02 EGS (CN#PL900-1): Added

SELECT A.BUSINESS_UNIT , A.DEMAND_SOURCE , A.SOURCE_BUS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NO , A.INV_ITEM_ID , A.DEMAND_LINE_NO , A.PL_SEQ_NBR , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.CONFIG_CODE , B.PLANNER_CD , A.DESTIN_BU , C.PLANNER_CD , A.INTERUNIT_FLG ,A.PLAN_NEW_FLG ,A.PROBINST , A.PLANNING_TIMESTAMP , A.SCHED_DTTM , A.PL_SCHED_DTTM , A.SCHED_ARRV_DTTM , A.PL_SCHED_ARRV_DTTM , A.PLAN_FROZEN_FLG , A.ORIG_FROZEN_FLG , A.PROCESS_INSTANCE , A.PEG_STATUS FROM PS_PL_IN_EXCEPT 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 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
3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
4 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
5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
6 SCHED_LINE_NO Number(7,2) DECIMAL(6,2) NOT NULL Sched Line NO
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
9 PL_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL 01/09/02 EGS (CN#PL900-1): Added
10 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
11 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
12 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
13 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code

Prompt Table: PLANNER_TBL

14 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
15 DEST_PLAN_CD Character(12) VARCHAR2(12) NOT NULL Destination Planner Code

Prompt Table: PLANNER_TBL

16 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes

Y/N Table Edit

17 PLAN_NEW_FLG Character(1) VARCHAR2(1) NOT NULL New Order / Schedule

Y/N Table Edit

18 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
19 PLANNING_TIMESTAMP DateTime(26) TIMESTAMP Planning Date and Time
20 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
21 PL_SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
22 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
23 PL_SCHED_ARRV_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
24 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes

Y/N Table Edit

25 ORIG_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 03/14/02 EGS (CN#PL900-1): Added.

Y/N Table Edit

26 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
27 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged