RTE_INV_TMP_VW (SQL View)	Index Back
Route Temp View This SQL View is used by various batch processes to perform an update to the Process Status when searching for transportation routes. 08/11/04 PWF F-KNANN-V59N4 Change key field from SCHED_LINE_NO to SCHED_LINE_NBR

RTE_INV_TMP_VW

(SQL View)

Route Temp View

This SQL View is used by various batch processes to perform an update to the Process Status when searching for transportation routes. 08/11/04 PWF F-KNANN-V59N4 Change key field from SCHED_LINE_NO to SCHED_LINE_NBR

SELECT A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.DEMAND_SOURCE , A.SOURCE_BUS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.INV_ITEM_ID , A.DEMAND_LINE_NO , A.PROCESS_STATUS FROM PS_ROUTE_INV_TMP A , PS_RTE_INV_TMP_CPY B WHERE A.PROCESS_INSTANCE = B.PROCESS_INSTANCE AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.DEMAND_SOURCE = B.DEMAND_SOURCE AND A.SOURCE_BUS_UNIT = B.SOURCE_BUS_UNIT AND A.ORDER_NO = B.ORDER_NO AND A.ORDER_INT_LINE_NO = B.ORDER_INT_LINE_NO AND A.SCHED_LINE_NBR = B.SCHED_LINE_NBR AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.DEMAND_LINE_NO = B.DEMAND_LINE_NO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 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

4 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

5 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

6 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

7 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

9 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

10 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	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
4	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
5	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
6	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
7	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
8	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
9	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
10	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success Default Value: N