IN_RLS_UNDO_VW

(SQL View)

SELECT DPI.BUSINESS_UNIT , DPI.DEMAND_SOURCE , DPI.SOURCE_BUS_UNIT , DPI.ORDER_NO , DPI.ORDER_INT_LINE_NO , DPI.SCHED_LINE_NBR , DPI.INV_ITEM_ID , DPI.DEMAND_LINE_NO , DPI.SEQ_NBR , ID.QTY_REQUESTED , ID.QTY_REQUESTED_BASE , ID.QTY_PROMISED_BASE , ID.QTY_ALLOCATED , ID.QTY_ALLOC_BASE , ID.QTY_BACKORDER , ID.QTY_BACKORDER_BASE , DPI.QTY_PICKED , DPI.QTY_BASE , DPI.QTY_PICKED_CONV , ID.QTY_PICK_OVRIDE , ID.QTY_PICK_OVR_BASE , ID.FULFILL_FLAG , ID.PICKLIST_PRINTED , ID.CONFIRMED_FLAG , ID.HARD_ALLOC_FLAG , ID.LOT_ALLOC_FLG , MI.PROMISE_OPTION , MI.LOT_CONTROL , MI.CFG_CODE_OPT , MI.UNIT_MEASURE_STD , USTD.CONVERSION_RATE , USTD.ROUND_RULE , USTD.QTY_PRECISION , ID.UNIT_OF_MEASURE , UORD.CONVERSION_RATE , UORD.ROUND_RULE , UORD.QTY_PRECISION , DPI.UNIT_MEASURE_PICK , UPCK.CONVERSION_RATE , UPCK.ROUND_RULE , UPCK.QTY_PRECISION , MI.SETID , PI.AVAIL_STATUS , PI.QTY , SLI.NETTABLE_FLG , BU.INCL_QUAR_AVAIL , DPI.ALLOCATE_SOURCE , BI.CONSIGNED_FLAG , DPI.QTY_SHIPPED , DPI.QTY_SHIP_BASE , DPI.QTY_SHIPPED_CONV , DPI.LAST_QTY_SHIP , DPI.LAST_QTY_SHIP_BASE FROM PS_DEMAND_PHYS_INV DPI , PS_IN_DEMAND ID , PS_MASTER_ITEM_TBL MI , PS_SET_CNTRL_REC SCR , PS_INV_ITEM_UOM USTD , PS_INV_ITEM_UOM UORD , PS_INV_ITEM_UOM UPCK , PS_PHYSICAL_INV PI , PS_STOR_LOC_INV SLI , PS_BUS_UNIT_TBL_IN BU , PS_BU_ITEMS_INV BI WHERE %Join(COMMON_KEYS, DEMAND_PHYS_INV DPI, IN_DEMAND ID) AND DPI.BUSINESS_UNIT = SCR.SETCNTRLVALUE AND SCR.RECNAME = 'MASTER_ITEM_TBL' AND SCR.SETID = MI.SETID AND DPI.INV_ITEM_ID = MI.INV_ITEM_ID AND MI.SETID = USTD.SETID AND MI.INV_ITEM_ID = USTD.INV_ITEM_ID AND MI.UNIT_MEASURE_STD = USTD.UNIT_OF_MEASURE AND MI.SETID = UORD.SETID AND MI.INV_ITEM_ID = UORD.INV_ITEM_ID AND ID.UNIT_OF_MEASURE = UORD.UNIT_OF_MEASURE AND MI.SETID = UPCK.SETID AND MI.INV_ITEM_ID = UPCK.INV_ITEM_ID AND DPI.UNIT_MEASURE_PICK = UPCK.UNIT_OF_MEASURE AND %Join(COMMON_FIELDS, DEMAND_PHYS_INV DPI, PHYSICAL_INV PI, QTY_BASE, AVAIL_STATUS, DT_TIMESTAMP) AND PI.UNIT_OF_MEASURE = DPI.UNIT_MEASURE_PICK AND DPI.BUSINESS_UNIT = BU.BUSINESS_UNIT AND %Join(COMMON_KEYS, PHYSICAL_INV PI, STOR_LOC_INV SLI) AND DPI.BUSINESS_UNIT = BI.BUSINESS_UNIT AND DPI.INV_ITEM_ID = BI.INV_ITEM_ID

# 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

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

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

12 QTY_PROMISED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Promised Base

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

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

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

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

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

18 QTY_PICKED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Pick Base

19 QTY_PICKED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked in Phys Loc UOM

20 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.

21 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.

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

23 PICKLIST_PRINTED Character(1) VARCHAR2(1) NOT NULL Picklist Printed
Y/N Table Edit
Default Value: N

24 CONFIRMED_FLAG Character(1) VARCHAR2(1) NOT NULL Confirm
Y/N Table Edit
Default Value: N

25 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate
Y/N Table Edit
Default Value: N

26 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation
Y/N Table Edit
Default Value: N

27 PROMISE_OPTION Character(1) VARCHAR2(1) NOT NULL Order Promise Option
2=Perform ATP Reservations

28 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y

29 CFG_CODE_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Code Generation
B=Both
N=No
Y=Yes

30 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

31 CONVERSION_RATE1 Signed Number(17,8) DECIMAL(15,8) NOT NULL Req UOM conversion rate

32 ROUND_RULE_STD Character(1) VARCHAR2(1) NOT NULL Rounding Rule
N=Natural Round
U=Round Up

33 QTY_PREC_STD Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number

34 UNIT_MEASURE_ORD Character(3) VARCHAR2(3) NOT NULL Ordering UOM

35 CONVERSION_RATE2 Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate

36 ROUND_RULE_ORDR Character(1) VARCHAR2(1) NOT NULL Rounding Rule
N=Natural Round
U=Round Up

37 QTY_PREC_ORDR Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number

38 UNIT_MEASURE_PICK Character(3) VARCHAR2(3) NOT NULL Phys Location Unit of Measure

39 CONVERSION_RATE3 Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate

40 ROUND_RULE_STCK Character(1) VARCHAR2(1) NOT NULL Rounding Rule
N=Natural Round
U=Round Up

41 QTY_PREC_STCK Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number

42 SETID_INV_ITEM Character(5) VARCHAR2(5) NOT NULL Inv Items SETID

43 AVAIL_STATUS Character(1) VARCHAR2(1) NOT NULL Availability Status
1=Open
2=Restricted
3=Hold
4=Rejected

44 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity

45 NETTABLE_FLG Character(1) VARCHAR2(1) NOT NULL Nettable

46 INCL_QUAR_AVAIL Character(1) VARCHAR2(1) NOT NULL Incl Non-Open in Avail Qty

47 ALLOCATE_SOURCE Character(2) VARCHAR2(2) NOT NULL Allocation Source - Why was the allocation created
LT=Lot Allocation
PR=Pre-allocation
SA=Standard Allocation

48 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag

49 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped

50 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base

51 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped

52 LAST_QTY_SHIP Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Last Shipped

53 LAST_QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Used to save the last value of quantity shipped from the Shipping Issues Panel in Standard UOM at the DEMAND_PHYS_INV and SHIP_INF_INV level. Default to the quantity picked from the Express Issues Panel or for cases where auto ship equals 'Y'.

#	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	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
10	QTY_REQUESTED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested
11	QTY_REQUESTED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested Base
12	QTY_PROMISED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Promised Base
13	QTY_ALLOCATED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Allocated quantity
14	QTY_ALLOC_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity allocation
15	QTY_BACKORDER	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Backorder Qty
16	QTY_BACKORDER_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Backorder Base Qty
17	QTY_PICKED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Picked
18	QTY_PICKED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Pick Base
19	QTY_PICKED_CONV	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Picked in Phys Loc UOM
20	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.
21	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.
22	FULFILL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	OK to Pick Y/N Table Edit Default Value: N
23	PICKLIST_PRINTED	Character(1)	VARCHAR2(1) NOT NULL	Picklist Printed Y/N Table Edit Default Value: N
24	CONFIRMED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Confirm Y/N Table Edit Default Value: N
25	HARD_ALLOC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Hard Allocate Y/N Table Edit Default Value: N
26	LOT_ALLOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow Lot Allocation Y/N Table Edit Default Value: N
27	PROMISE_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Order Promise Option 2=Perform ATP Reservations
28	LOT_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Lot Control N=N Y=Y
29	CFG_CODE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Configuration Code Generation B=Both N=No Y=Yes
30	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
31	CONVERSION_RATE1	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Req UOM conversion rate
32	ROUND_RULE_STD	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule N=Natural Round U=Round Up
33	QTY_PREC_STD	Character(1)	VARCHAR2(1) NOT NULL	Quantity Precision D=Decimal Number W=Whole Number
34	UNIT_MEASURE_ORD	Character(3)	VARCHAR2(3) NOT NULL	Ordering UOM
35	CONVERSION_RATE2	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
36	ROUND_RULE_ORDR	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule N=Natural Round U=Round Up
37	QTY_PREC_ORDR	Character(1)	VARCHAR2(1) NOT NULL	Quantity Precision D=Decimal Number W=Whole Number
38	UNIT_MEASURE_PICK	Character(3)	VARCHAR2(3) NOT NULL	Phys Location Unit of Measure
39	CONVERSION_RATE3	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
40	ROUND_RULE_STCK	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule N=Natural Round U=Round Up
41	QTY_PREC_STCK	Character(1)	VARCHAR2(1) NOT NULL	Quantity Precision D=Decimal Number W=Whole Number
42	SETID_INV_ITEM	Character(5)	VARCHAR2(5) NOT NULL	Inv Items SETID
43	AVAIL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Availability Status 1=Open 2=Restricted 3=Hold 4=Rejected
44	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
45	NETTABLE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Nettable
46	INCL_QUAR_AVAIL	Character(1)	VARCHAR2(1) NOT NULL	Incl Non-Open in Avail Qty
47	ALLOCATE_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Allocation Source - Why was the allocation created LT=Lot Allocation PR=Pre-allocation SA=Standard Allocation
48	CONSIGNED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Consigned Flag
49	QTY_SHIPPED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Shipped
50	QTY_SHIP_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Ship Base
51	QTY_SHIPPED_CONV	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Shipped
52	LAST_QTY_SHIP	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Last Shipped
53	LAST_QTY_SHIP_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Used to save the last value of quantity shipped from the Shipping Issues Panel in Standard UOM at the DEMAND_PHYS_INV and SHIP_INF_INV level. Default to the quantity picked from the Express Issues Panel or for cases where auto ship equals 'Y'.