IN_PEG_SUP_XSVW

(SQL View)
 Index Back

Pegging Table

06/16/04 EGS: Created.

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 , D.BUSINESS_UNIT , D.DEMAND_SOURCE , D.SOURCE_BUS_UNIT , D.ORDER_NO , D.ORDER_INT_LINE_NO , D.SCHED_LINE_NBR , D.DEMAND_LINE_NO , D.QTY_REQUESTED_BASE - D.QTY_ALLOC_BASE - D.QTY_BACKORDER_BASE , B.QTY_PEGGED , B.QTY_RECEIVED , B.QTY_COMPLETE , B.PEG_STATUS , D.INTERUNIT_ID , D.INTERUNIT_LINE , F.SCHED_DTTM , F.PRIORITY_NBR , B.DEMAND_HASH , B.DMD_ORDER_TYPE , B.SUPPLY_HASH , B.SUP_ORDER_TYPE FROM PS_IN_DEMAND_HASH A , PS_IN_PEGGING B , PS_IN_DEMAND_HASH C , PS_IN_DEMAND D , PS_IN_DEMAND F WHERE A.HASH_KEY = B.DEMAND_HASH AND B.SUPPLY_HASH = C.HASH_KEY AND B.SUP_ORDER_TYPE = '035' AND B.PEG_STATUS = '10' AND D.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.DEMAND_SOURCE = C.DEMAND_SOURCE AND D.SOURCE_BUS_UNIT = C.SOURCE_BUS_UNIT AND D.ORDER_NO = C.ORDER_NO AND D.ORDER_INT_LINE_NO = C.ORDER_INT_LINE_NO AND D.SCHED_LINE_NBR = C.SCHED_LINE_NBR AND D.INV_ITEM_ID = C.INV_ITEM_ID AND D.DEMAND_LINE_NO = C.DEMAND_LINE_NO AND F.BUSINESS_UNIT = C.BUSINESS_UNIT AND F.DEMAND_SOURCE = C.DEMAND_SOURCE AND F.SOURCE_BUS_UNIT = C.SOURCE_BUS_UNIT AND F.ORDER_NO = C.ORDER_NO AND F.ORDER_INT_LINE_NO = C.ORDER_INT_LINE_NO AND F.SCHED_LINE_NBR = C.SCHED_LINE_NBR AND F.INV_ITEM_ID = C.INV_ITEM_ID AND F.DEMAND_LINE_NO = C.DEMAND_LINE_NO AND ((QTY_PEGGED-QTY_COMPLETE)>0)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
2 DMD_SOURCE Character(2) VARCHAR2(2) NOT NULL 08/13/04 EGS: Created.
3 BUS_UNIT_SOURCE Character(5) VARCHAR2(5) NOT NULL Source Business Unit
4 DMD_ORDER_NO Character(10) VARCHAR2(10) NOT NULL 08/13/04 EGS: Create
5 DMD_INT_LINE_NO Number(5,0) INTEGER NOT NULL 08/13/04 EGS: Created
6 DMD_SCHED_LINE Number(6,0) INTEGER NOT NULL 08/13/04 EGS: Created
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 DMD_LINE_NO Number(4,0) SMALLINT NOT NULL 08/13/04 EGS: Created
9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
10 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
11 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
12 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
13 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
14 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
15 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
16 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
17 QTY_PEGGED Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/16/04 EGS: Created.
18 QTY_RECEIVED Number(16,4) DECIMAL(15,4) NOT NULL Received Qty
19 QTY_COMPLETE Number(16,4) DECIMAL(15,4) NOT NULL Quantity Complete
20 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged

Default Value: 10

21 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
22 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
23 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
24 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
25 DEMAND_HASH Character(28) VARCHAR2(28) NOT NULL 08/11/04 EGS: Created.
26 DMD_ORDER_TYPE Character(4) VARCHAR2(4) NOT NULL Used by Pegging Maintenance/Inquiry
030=Transfer Demand
070=Stock Request
090=Sales Order
110=Work Order Inventory
115=WO Non-Inventory
900=Work Order
27 SUPPLY_HASH Character(28) VARCHAR2(28) NOT NULL 08/11/04 EGS: Created.
28 SUP_ORDER_TYPE Character(4) VARCHAR2(4) NOT NULL Used by Pegging Maintenance/Inquiry
010=Purchase
020=Production
035=Transfer Supply
100=Requisition