DEMAND_PICK_VW5

(SQL View)
 Index Back

Demand Order Picking View


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.LOAD_ID , A.CARRIER_ID , A.SHIP_TYPE_ID , A.PARENT_PROD_ID , A.SCHED_DATE , A.SCHED_TIME , A.SCHED_ARRV_DTTM , A.INTERUNIT_FLG , A.DESTIN_BU , A.PICK_BATCH_ID , A.LOCATION , A.PICKLIST_LINE_NO , A.CUST_ID , A.CUST_NAME , A.SHIP_TO_CUST_ID , A.SHIP_CUST_NAME1 , A.SHIP_CUST_NAME2 , A.QTY_REQUESTED , A.QTY_REQUESTED_BASE , A.QTY_ALLOCATED , A.QTY_ALLOC_BASE , A.QTY_PICKED , A.QTY_PICK_OVRIDE , A.QTY_BACKORDER , A.QTY_BACKORDER_BASE , A.QTY_SHIPPED , A.QTY_PROMISED_BASE , A.UNIT_OF_MEASURE , A.HARD_ALLOC_FLAG , A.CONFIRMED_FLAG , A.DISTRIB_TYPE , A.LOT_ALLOC_FLG , A.CONFIG_CODE , A.PARTIAL_QTY_FLAG , A.PICKLIST_PRINTED , A.TRANSFER_YIELD , A.ROUTE_CD , A.ROUTE_STOP_NBR , A.PICK_DTTM , A.ORIG_INV_ITEM_ID , A.ORIG_UOM , A.ALLOW_SUB_ITEM_FLG , A.EXPORT , A.ALLOW_OVERPICK_FLG , A.MAX_PICK_TOLERANCE , A.EXT_REF_NBR , A.EXT_REF_LN_NBR , A.SHIP_ID , A.SHIP_LINE_NO , A.PRODUCT_ID , A.HOLD_FLAG , A.HOLD_CD , A.PICK_RELEASE_ID , A.IN_FULFILL_STATE , A.IN_ZERO_PICKED_FLG , A.DT_TIMESTAMP , A.LAST_PROCESS_INST , A.QTY_PER , A.QTY_CODE , A.OPTIONAL_SHIP , A.RESERVE_STATUS , A.PEG_STATUS , A.UNIT_MEASURE_STD , A.DESCR , A.OPRID_OWNER , B.UNIT_MEASURE_PICK , B.QTY , B.INV_LOT_ID , B.SERIAL_ID , B.STORAGE_AREA , B.STOR_LEVEL_1 , B.STOR_LEVEL_2 , B.STOR_LEVEL_3 , B.STOR_LEVEL_4 , B.QTY_PICKED_CONV , B.QTY_BASE FROM %Table(DEMAND_PICK_VW4) A , %Table(OM_DMDPHYINV_VW) B WHERE 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 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

Prompt Table: SP_BU_FS_NONVW

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_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITM_INV_VW2

8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
9 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

Prompt Table: LOAD_INV_OPN_VW

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

Prompt Table: CARRIER_ID

11 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD

12 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
13 SCHED_DATE Date(10) DATE Schedule Date
14 SCHED_TIME Time(15) TIMESTAMP Schedule Time
15 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
16 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes

Y/N Table Edit

17 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
18 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
19 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
20 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
21 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.
22 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
23 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
24 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
25 SHIP_CUST_NAME2 Character(40) VARCHAR2(40) NOT NULL Ship To Name 2
26 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
27 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
28 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
29 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation
30 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
31 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.
32 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
33 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty
34 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
35 QTY_PROMISED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Promised Base
36 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: INV_ORD3_UOM_VW

37 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate
38 CONFIRMED_FLAG Character(1) VARCHAR2(1) NOT NULL Confirm

Y/N Table Edit

Default Value: N

39 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
40 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation
41 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
42 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship
43 PICKLIST_PRINTED Character(1) VARCHAR2(1) NOT NULL Picklist Printed
44 TRANSFER_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Transfer Yield
45 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.

Prompt Table: ROUTE_INV_VW

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

Prompt Table: ROUTE_STOP_VW2

47 PICK_DTTM DateTime(26) TIMESTAMP Picked Date/Time
48 ORIG_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Used to identify the original item ordered, in case an item substitution has taken place.
49 ORIG_UOM Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
50 ALLOW_SUB_ITEM_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether item substitutions are allowed on the order schedule.

Y/N Table Edit

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

Y/N Table Edit

52 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.
53 MAX_PICK_TOLERANCE Number(6,2) DECIMAL(5,2) NOT NULL Used to indicate the allowable percentage of overshipment for a customer or business unit.
54 EXT_REF_NBR Number(10,0) DECIMAL(10) NOT NULL External Reference Number
55 EXT_REF_LN_NBR Number(5,0) INTEGER NOT NULL External Reference Line Number
56 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
57 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
58 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
59 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold
60 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code
61 PICK_RELEASE_ID Number(10,0) DECIMAL(10) NOT NULL Pick Release ID
62 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
63 IN_ZERO_PICKED_FLG Character(1) VARCHAR2(1) NOT NULL Zero Picked

Y/N Table Edit

64 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
65 LAST_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
66 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity
67 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
68 OPTIONAL_SHIP Character(1) VARCHAR2(1) NOT NULL OK to Ship Without
69 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
70 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
71 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
72 DESCR Character(30) VARCHAR2(30) NOT NULL Description
73 OPRID_OWNER Character(30) VARCHAR2(30) NOT NULL Operator id of the owner of a document

Prompt Table: OPRID_VW

74 UNIT_MEASURE_PICK Character(3) VARCHAR2(3) NOT NULL Phys Location Unit of Measure
75 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
76 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
77 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
78 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
79 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
80 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
81 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
82 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
83 QTY_PICKED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked in Phys Loc UOM
84 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity