IN_DMD_NP_VW

(SQL View)
 Index Back

IN Peg MSR Search View

06/21/04 EGS: Created

SELECT A.BUSINESS_UNIT , A.BUSINESS_UNIT , A.DESTIN_BU , 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 , '070' , A.QTY_REQUESTED_BASE - A.QTY_BACKORDER_BASE , A.QTY_REQUESTED_BASE - A.QTY_BACKORDER_BASE , A.QTY_ALLOC_BASE , 'N' , %DatePart(A.SCHED_DTTM) , %TimePart(A.SCHED_DTTM) , A.SCHED_DTTM , 'N' , A.INTERUNIT_FLG , A.PEG_STATUS , A.PRIORITY_NBR FROM PS_IN_DEMAND A WHERE A.IN_FULFILL_STATE = '20' AND A.IN_PROCESS_DATE IS NOT NULL AND A.APPROVED_FLAG = 'Y' AND A.PEG_STATUS IN ('30', '40') AND A.QTY_REQUESTED_BASE - A.QTY_ALLOC_BASE - A.QTY_BACKORDER_BASE > 0 AND (EXISTS ( SELECT 'X' FROM PS_DF_SETUP_IT_INV WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND INV_ITEM_ID = A.INV_ITEM_ID AND SOFT_ALLOC_FLG = 'Y') OR (NOT EXISTS ( SELECT 'X' FROM PS_DF_SETUP_IT_INV WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND INV_ITEM_ID = A.INV_ITEM_ID) AND EXISTS ( SELECT 'X' FROM PS_DF_SETUP_INV WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND SOFT_ALLOC_FLG = 'Y')))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
3 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
4 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
5 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
6 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
7 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
8 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
10 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
11 PEG_ORDER_TYPE Character(4) VARCHAR2(4) NOT NULL Used by Pegging Maintenance/Inquiry
010=Purchase
020=Production
030=Transfer Demand
035=Transfer Supply
070=Stock Request
090=Sales Order
100=Requisition
110=WO Inventory
115=WO Non-Inventory
12 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
13 QTY_ORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/21/04 EGS: Created
14 QTY_COMPLETE Number(16,4) DECIMAL(15,4) NOT NULL Quantity Complete
15 PEG_FLAG Character(1) VARCHAR2(1) NOT NULL 06/17/04 EGS: Created.
16 SCHED_DATE Date(10) DATE Schedule Date
17 SCHED_TIME Time(15) TIMESTAMP Schedule Time
18 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
19 HARD_PEG Character(1) VARCHAR2(1) NOT NULL 09/01/04 EGS: Created
20 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes
21 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
22 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority