OMOT_DEMAND_VW

(SQL View)
 Index Back

Schedule Demand View

Schedule Demand View Date Initials Issue Description 052704 twh F-KNANN-V59N4 Replace demand table references with IN_DEMAND

SELECT SOURCE_BUS_UNIT , ORDER_NO , ORDER_INT_LINE_NO , SCHED_LINE_NBR , DEMAND_LINE_NO , INV_ITEM_ID , KIT_LINE_NBR , BUSINESS_UNIT , PARENT_PROD_ID , QTY_REQUESTED , QTY_ALLOCATED , QTY_BACKORDER , %DatePart(RESERVED_DTTM) , REQUEST_DATE , 'D' FROM PS_IN_DEMAND WHERE DEMAND_SOURCE = 'OM' AND IN_FULFILL_STATE = '20'

# 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 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
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

Default Value: 1

6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITM_INV_VW2

7 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
8 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
9 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
10 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
11 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
12 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
13 RESERVED_DATE Date(10) DATE Date on which a demand line was soft reserved.
14 REQUEST_DATE Date(10) DATE Requested
15 SOURCE_IND Character(1) VARCHAR2(1) NOT NULL Source Indicator