IN_SDWC_INT_VW

(SQL View)
 Index Back

EOEN Context Record

Intransit past scheduled date

SELECT %subrec(IN_DMD_NKEY_SBR, A) , %subrec(IN_SDWC_DMD_SBR, A) , %subrec(IN_SDWC_INT_SBR, A) , %DatePart(A.SCHED_ARRV_DTTM) , A.BUSINESS_UNIT %Concat '~' %Concat A.DEMAND_SOURCE %Concat '~' %Concat A.SOURCE_BUS_UNIT %Concat '~' %Concat A.ORDER_NO %Concat '~' %Concat %NumToChar(A.ORDER_INT_LINE_NO) %Concat '~' %Concat %NumToChar(A.SCHED_LINE_NBR) %Concat '~' %Concat %NumToChar(A.DEMAND_LINE_NO) %Concat '~' %Concat A.INTERUNIT_ID %Concat '~' %Concat %NumToChar(A.INTERUNIT_LINE) FROM PS_IN_DEMAND A WHERE A.IN_PROCESS_DATE IS NOT NULL AND %DatePart(A.SCHED_ARRV_DTTM) < %CurrentDateIn AND A.INTERUNIT_FLG = 'Y' AND A.INTERUNIT_STAT IN ('I','O','P') AND A.IN_FULFILL_STATE <= '60' AND NOT EXISTS ( SELECT B.SCHED_ARRV_DATE FROM PS_IN_SDWC_INT_CTX B , PS_EOEN_DASHBRD C WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.DEMAND_SOURCE = A.DEMAND_SOURCE AND B.SOURCE_BUS_UNIT = A.SOURCE_BUS_UNIT AND B.ORDER_NO = A.ORDER_NO AND B.ORDER_INT_LINE_NO = A.ORDER_INT_LINE_NO AND B.SCHED_LINE_NBR = A.SCHED_LINE_NBR AND B.DEMAND_LINE_NO = A.DEMAND_LINE_NO AND B.INV_ITEM_ID = A.INV_ITEM_ID AND B.EOEN_PRCS_NAME = C.EOEN_PRCS_NAME AND B.EOEN_CATEGORY = C.EOEN_CATEGORY AND B.SEQ_NBR_EOEN = C.SEQ_NBR_EOEN AND C.EOEN_STATUS = '0') UNION SELECT %subrec(IN_DMD_NKEY_SBR, A) , %subrec(IN_SDWC_DMD_SBR, A) , %subrec(IN_SDWC_INT_SBR, A) , %DatePart(A.SCHED_ARRV_DTTM) , A.BUSINESS_UNIT %Concat '~' %Concat A.DEMAND_SOURCE %Concat '~' %Concat A.SOURCE_BUS_UNIT %Concat '~' %Concat A.ORDER_NO %Concat '~' %Concat %NumToChar(A.ORDER_INT_LINE_NO) %Concat '~' %Concat %NumToChar(A.SCHED_LINE_NBR) %Concat '~' %Concat %NumToChar(A.DEMAND_LINE_NO) %Concat '~' %Concat A.INTERUNIT_ID %Concat '~' %Concat %NumToChar(A.INTERUNIT_LINE) FROM PS_IN_DEMAND A WHERE A.IN_PROCESS_DATE IS NULL AND %DatePart(A.SCHED_ARRV_DTTM) < %CurrentDateIn AND A.INTERUNIT_FLG = 'Y' AND A.INTERUNIT_STAT IN ('I','O','P') AND A.IN_FULFILL_STATE = '70' AND NOT EXISTS ( SELECT B.SCHED_ARRV_DATE FROM PS_IN_SDWC_INT_CTX B , PS_EOEN_DASHBRD C WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.DEMAND_SOURCE = A.DEMAND_SOURCE AND B.SOURCE_BUS_UNIT = A.SOURCE_BUS_UNIT AND B.ORDER_NO = A.ORDER_NO AND B.ORDER_INT_LINE_NO = A.ORDER_INT_LINE_NO AND B.SCHED_LINE_NBR = A.SCHED_LINE_NBR AND B.DEMAND_LINE_NO = A.DEMAND_LINE_NO AND B.INV_ITEM_ID = A.INV_ITEM_ID AND B.EOEN_PRCS_NAME = C.EOEN_PRCS_NAME AND B.EOEN_CATEGORY = C.EOEN_CATEGORY AND B.SEQ_NBR_EOEN = C.SEQ_NBR_EOEN AND C.EOEN_STATUS = '0')

# 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 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
8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_ITEM

10 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
11 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
12 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
13 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: CUST_SHPINV_VW

14 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
15 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
16 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
17 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
18 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
19 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
20 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty
21 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity
22 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
23 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
24 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
25 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
26 SUP_PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Unpegged
27 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes
28 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.
29 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
30 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
31 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
32 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes
33 INTERUNIT_STAT Character(1) VARCHAR2(1) NOT NULL InterUnit Status
C=Cancelled
I=In-Transit
O=Open
P=Picked
R=Received
34 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
35 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
36 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
37 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
38 IN_PROCESS_DATE Date(10) DATE Process Date
39 SCHED_ARRV_DATE Date(10) DATE Scheduled Arrival Date
40 IN_SDWC_HASH_KEY Character(60) VARCHAR2(60) NOT NULL Hash