IN_RLS_UNDO2_VW

(SQL View)
 Index Back

SELECT ID.BUSINESS_UNIT , ID.DEMAND_SOURCE , ID.SOURCE_BUS_UNIT , ID.ORDER_NO , ID.ORDER_INT_LINE_NO , ID.SCHED_LINE_NBR , ID.INV_ITEM_ID , ID.DEMAND_LINE_NO , 0 , 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 , 0 , 0 , 0 , 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 , ' ' , 0 , ' ' , ' ' , MI.SETID , 0 , 0 , 0 , 0 , 0 FROM PS_IN_DEMAND ID , PS_MASTER_ITEM_TBL MI , PS_SET_CNTRL_REC SCR , PS_INV_ITEM_UOM USTD , PS_INV_ITEM_UOM UORD WHERE ID.BUSINESS_UNIT = SCR.SETCNTRLVALUE AND SCR.RECNAME = 'MASTER_ITEM_TBL' AND SCR.SETID = MI.SETID AND ID.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

# 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 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
44 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
45 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
46 LAST_QTY_SHIP Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Last Shipped
47 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'.