IN_SDWCHL1_OPRV

(SQL View)
 Index Back

Demand on hold view

No security

SELECT 'IN_SDWC_PASTSHIP_HOLD' , 'SUP_DMD_ALERTS' , 0 , %subrec(IN_DMD_NKEY_SBR, I) , 0 , H.HOLD_CD , H.PROD_COMPONENT_ID , %subrec(IN_SDWC_DMD_SBR, I) , %subrec(IN_SDWC_PRC_SBR, V) , %DatePart(I.SCHED_DTTM) , I.BUSINESS_UNIT %Concat '~' %Concat I.DEMAND_SOURCE %Concat '~' %Concat I.SOURCE_BUS_UNIT %Concat '~' %Concat I.ORDER_NO %Concat '~' %Concat %NumToChar(I.ORDER_INT_LINE_NO) %Concat '~' %Concat %NumToChar(I.SCHED_LINE_NBR) %Concat '~' %Concat %NumToChar(I.DEMAND_LINE_NO) , I.QTY_REQUESTED - I.QTY_BACKORDER , I.QTY_REQUESTED_BASE - I.QTY_BACKORDER_BASE , H.ORDER_INT_LINE_NO , H.SCHED_LINE_NBR , 'O' , 0 , S.OPRID FROM PS_IN_DEMAND I , PS_IN_SDWC_SCH2_VW V , PS_ORD_HOLD H , PS_SEC_BU_OPR S , PS_SEC_BU_OPR S1 WHERE %Join(COMMON_KEYS, IN_SDWC_SCH_VW V, IN_DEMAND I) AND S.BUSINESS_UNIT = I.BUSINESS_UNIT AND S1.OPRID = S.OPRID AND S1.BUSINESS_UNIT = I.SOURCE_BUS_UNIT AND I.IN_PROCESS_DATE IS NOT NULL AND I.DEMAND_SOURCE = 'OM' AND I.IN_FULFILL_STATE BETWEEN '10' AND '50' AND %DatePart(I.SCHED_DTTM) < %CurrentDateIn AND V.CUST_PICKUP = 'N' AND H.BUSINESS_UNIT = I.SOURCE_BUS_UNIT AND H.ORDER_NO = I.ORDER_NO AND (( H.ORDER_INT_LINE_NO = 0 AND H.SCHED_LINE_NBR = 0) OR ( H.ORDER_INT_LINE_NO = I.ORDER_INT_LINE_NO AND H.SCHED_LINE_NBR = 0) OR ( H.ORDER_INT_LINE_NO = I.ORDER_INT_LINE_NO AND H.SCHED_LINE_NBR = I.SCHED_LINE_NBR)) AND H.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Process Name
2 EOEN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EOEN Category
3 SEQ_NBR_EOEN Number(15,0) DECIMAL(15) NOT NULL EOEN Sequence Nbr
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_OM_NONVW

5 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
6 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

Prompt Table: SP_BU_FS_NONVW

7 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
8 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
9 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
11 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
12 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
13 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code

Prompt Table: HOLD_CD

14 PROD_COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL Product Component ID

Prompt Table: PROD_NOTKIT_VW

15 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_ITEM

16 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
17 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
18 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
19 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: CUST_SHPINV_VW

20 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
21 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
22 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
23 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
24 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
25 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
26 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty
27 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity
28 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
29 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
30 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
31 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
32 SUP_PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Unpegged
33 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes
34 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.
35 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
36 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
37 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
38 TOTAL_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Quantity
39 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
40 EXTENDED_NET_PRICE Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Amount
41 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
42 IN_PROCESS_DATE Date(10) DATE Process Date
43 SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date
44 IN_SDWC_HASH_KEY Character(60) VARCHAR2(60) NOT NULL Hash
45 QTY_ORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/21/04 EGS: Created
46 QTY_ORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/21/04 EGS: Created
47 HOLD_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
48 HOLD_SCHED_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
49 EOEN_STATUS Character(1) VARCHAR2(1) NOT NULL EOEN Status
0=Open
1=Closed
50 ROWNBR Number(7,0) INTEGER NOT NULL Row number
51 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).