IN_RLS_PRMT_VW (SQL View)	Index Back
Demand Order Release View This view is used by the Order Release secondary panel to initially fetch all rows meeting the selection criteria on the picking plan run control panel. NOTE: There is a Sybase version of the viewtext associated with this record. If it is modified, please be sure to modify the platform-specific viewtext for Sybase.

IN_RLS_PRMT_VW

(SQL View)

Demand Order Release View

This view is used by the Order Release secondary panel to initially fetch all rows meeting the selection criteria on the picking plan run control panel. NOTE: There is a Sybase version of the viewtext associated with this record. If it is modified, please be sure to modify the platform-specific viewtext for Sybase.

SELECT 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.BUSINESS_UNIT , A.BUSINESS_UNIT , A.DEMAND_SOURCE , A.SOURCE_BUS_UNIT , A.ORDER_NO , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.SCHED_LINE_NBR , A.INV_ITEM_ID , A.DEMAND_LINE_NO , A.PICK_BATCH_ID , A.PICK_BATCH_ID , A.PICKLIST_LINE_NO , A.PICKLIST_LINE_NO , A.TMS_EXT_REF_ID , A.CARRIER_ID , A.SCHED_DTTM , A.DESTIN_BU , A.CARRIER_ID , A.LOAD_ID , A.SHIP_TYPE_ID , A.LOCATION , A.CUST_ID , A.CUST_NAME , A.SHIP_TO_CUST_ID , A.SHIP_CUST_NAME1 , A.SHIP_CUST_NAME2 , A.ADDRESS_SEQ_NUM , A.EXPORT , A.QTY_REQUESTED , A.QTY_REQUESTED_BASE , A.QTY_ALLOCATED , A.QTY_ALLOC_BASE , A.UNIT_OF_MEASURE , A.QTY_PICKED , A.QTY_PICK_OVRIDE , A.QTY_PICK_OVR_BASE , A.QTY_BACKORDER , A.QTY_BACKORDER_BASE , A.IN_FULFILL_STATE , A.FULFILL_FLAG , A.RESERVE_STATUS , A.CONFIRMED_FLAG , A.PICK_RELEASE_ID , A.ROUTE_CD , A.ROUTE_STOP_NBR , A.TMS_EXT_REF_ID , A.TMS_PROCESS_FLG , A.PICK_BATCH_ID , A.HOLD_FLAG , A.PICKLIST_PRINTED , A.APPROVED_FLAG , A.IN_ZERO_PICKED_FLG , A.RELEASE_INSTANCE , A.SHIP_ID , A.SHIP_ID , A.SHIP_ID , A.LOT_ALLOC_FLG , A.HARD_ALLOC_FLAG FROM PS_IN_DEMAND A WHERE in_process_date IS NOT NULL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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
Prompt Table: DEMAND_PICK_VW

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

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

7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: MST_ITM_PRPT_VW

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

9 SL_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit selection field
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW

10 TO_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit selection field

11 SL_DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source selection
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Sourced Demand
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order Demand

12 SL_SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Business Unit selection

13 SL_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Order Number selection

14 TO_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Order Number selection

15 SL_ORDER_INT_LINE Number(5,0) INTEGER NOT NULL Order Line selection

16 TO_ORDER_INT_LINE Number(5,0) INTEGER NOT NULL Order Line selection

17 SL_SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL 05/07/04 PWF Added field for new 8.9 data model changes

18 TO_SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL 05/07/04 PWF Added field for 8.9 data model changes

19 SL_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item selection

20 SL_DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line Number selection

21 SL_PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID selection

22 TO_PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID selection

23 SL_PICKLIST_LINE Number(7,0) INTEGER NOT NULL Pick List Line Number selection

24 TO_PICKLIST_LINE Number(7,0) INTEGER NOT NULL Pick List Line Number selection

25 SL_TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL Transportation Management System (TMS) Reference ID selection

26 TO_CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier selection

27 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added

28 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit

29 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

30 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

31 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
Prompt Table: SHIP_METHOD

32 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

33 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

34 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name

35 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

36 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name

37 SHIP_CUST_NAME2 Character(40) VARCHAR2(40) NOT NULL Ship To Name 2

38 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

39 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

40 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested

41 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base

42 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity

43 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation

44 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

45 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked

46 QTY_PICK_OVRIDE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to override the net requested quantity when printing the pick play for non-soft reservation items.

47 QTY_PICK_OVR_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to override the net requested quantity in standard uom when printing the pick play for non-soft reservation items.

48 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty

49 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty

50 IN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled

51 FULFILL_FLAG Character(1) VARCHAR2(1) NOT NULL OK to Pick
Y/N Table Edit
Default Value: N

52 RESERVE_STATUS Character(2) VARCHAR2(2) NOT NULL Reservation Status
10=Pending
11=Unreserved
12=Shortage, Rules Not Met
15=Reserved, Rules Not Met
21=Shortage, Line Rule Met
22=Reserved, Line Rule Met
31=Shortage, All Rules Met
32=Reserved, All Rules Met
40=Reserve Run
99=Invalid

53 CONFIRMED_FLAG Character(1) VARCHAR2(1) NOT NULL Confirm

54 PICK_RELEASE_ID Number(10,0) DECIMAL(10) NOT NULL Pick Release ID

55 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.

56 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.

57 TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL TMS Reference ID

58 TMS_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL TMS Process Flag

59 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID

60 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold

61 PICKLIST_PRINTED Character(1) VARCHAR2(1) NOT NULL Picklist Printed

62 APPROVED_FLAG Character(1) VARCHAR2(1) NOT NULL Approved
B=Both
N=No
Y=Yes

63 IN_ZERO_PICKED_FLG Character(1) VARCHAR2(1) NOT NULL Zero Picked

64 RELEASE_INSTANCE Number(10,0) DECIMAL(10) NOT NULL 08/2004 rcw: Order Release Instance

65 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID

66 SL_SHIP_ID Character(10) VARCHAR2(10) NOT NULL Ship ID Selection

67 TO_SHIP_ID Character(10) VARCHAR2(10) NOT NULL Ship ID Selection

68 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation

69 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	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 Prompt Table: DEMAND_PICK_VW
5	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
6	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
7	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: MST_ITM_PRPT_VW
8	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
9	SL_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit selection field Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW
10	TO_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit selection field
11	SL_DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Demand Source selection IN=Material Request OM=Sales Order PL=Planning Requisition PO=Sourced Demand PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order Demand
12	SL_SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Business Unit selection
13	SL_ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Order Number selection
14	TO_ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Order Number selection
15	SL_ORDER_INT_LINE	Number(5,0)	INTEGER NOT NULL	Order Line selection
16	TO_ORDER_INT_LINE	Number(5,0)	INTEGER NOT NULL	Order Line selection
17	SL_SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	05/07/04 PWF Added field for new 8.9 data model changes
18	TO_SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	05/07/04 PWF Added field for 8.9 data model changes
19	SL_INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item selection
20	SL_DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line Number selection
21	SL_PICK_BATCH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Batch ID selection
22	TO_PICK_BATCH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Batch ID selection
23	SL_PICKLIST_LINE	Number(7,0)	INTEGER NOT NULL	Pick List Line Number selection
24	TO_PICKLIST_LINE	Number(7,0)	INTEGER NOT NULL	Pick List Line Number selection
25	SL_TMS_EXT_REF_ID	Character(10)	VARCHAR2(10) NOT NULL	Transportation Management System (TMS) Reference ID selection
26	TO_CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier selection
27	SCHED_DTTM	DateTime(26)	TIMESTAMP	08/16/01 JNW (CN#PL900-1.0): Added
28	DESTIN_BU	Character(5)	VARCHAR2(5) NOT NULL	Destination Unit
29	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
30	LOAD_ID	Character(10)	VARCHAR2(10) NOT NULL	Load ID
31	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: SHIP_METHOD
32	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
33	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
34	CUST_NAME	Character(40)	VARCHAR2(40) NOT NULL	Name
35	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
36	SHIP_CUST_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Ship To Name
37	SHIP_CUST_NAME2	Character(40)	VARCHAR2(40) NOT NULL	Ship To Name 2
38	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
39	EXPORT	Character(1)	VARCHAR2(1) NOT NULL	Export Analytic Instance N=No Y=Yes
40	QTY_REQUESTED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested
41	QTY_REQUESTED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested Base
42	QTY_ALLOCATED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Allocated quantity
43	QTY_ALLOC_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity allocation
44	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
45	QTY_PICKED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Picked
46	QTY_PICK_OVRIDE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Field used to override the net requested quantity when printing the pick play for non-soft reservation items.
47	QTY_PICK_OVR_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Field used to override the net requested quantity in standard uom when printing the pick play for non-soft reservation items.
48	QTY_BACKORDER	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Backorder Qty
49	QTY_BACKORDER_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Backorder Base Qty
50	IN_FULFILL_STATE	Character(2)	VARCHAR2(2) NOT NULL	Inventory Fulfillment State 10=Pending 20=Unfulfilled 30=Releasable 40=Released 50=Confirmed 60=Shipped 70=Depleted 90=Canceled
51	FULFILL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	OK to Pick Y/N Table Edit Default Value: N
52	RESERVE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Reservation Status 10=Pending 11=Unreserved 12=Shortage, Rules Not Met 15=Reserved, Rules Not Met 21=Shortage, Line Rule Met 22=Reserved, Line Rule Met 31=Shortage, All Rules Met 32=Reserved, All Rules Met 40=Reserve Run 99=Invalid
53	CONFIRMED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Confirm
54	PICK_RELEASE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Release ID
55	ROUTE_CD	Character(6)	VARCHAR2(6) NOT NULL	A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
56	ROUTE_STOP_NBR	Number(5,0)	INTEGER NOT NULL	An identifier used to sequence customer addresses/location for a given route.
57	TMS_EXT_REF_ID	Character(10)	VARCHAR2(10) NOT NULL	TMS Reference ID
58	TMS_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	TMS Process Flag
59	PICK_BATCH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Batch ID
60	HOLD_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Hold N=Hold Y=Hold
61	PICKLIST_PRINTED	Character(1)	VARCHAR2(1) NOT NULL	Picklist Printed
62	APPROVED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Approved B=Both N=No Y=Yes
63	IN_ZERO_PICKED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Zero Picked
64	RELEASE_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	08/2004 rcw: Order Release Instance
65	SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shipping ID
66	SL_SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship ID Selection
67	TO_SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship ID Selection
68	LOT_ALLOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow Lot Allocation
69	HARD_ALLOC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Hard Allocate