IN_SDWCINT_OPRV

(SQL View)
 Index Back

Intransit Lines Past Sched Dt

OPRID Security view

SELECT %subrec(EOEN_LOG_KEY, P) , %subrec(IN_SDWC_CTX_SBR, P) , %subrec(IN_DMD_NKEY_SBR, P) , %subrec(IN_SDWC_DMD_SBR, I) , %subrec(IN_SDWC_INT_SBR, P) , %DatePart(I.SCHED_ARRV_DTTM) , P.IN_SDWC_HASH_KEY , D.EOEN_STATUS , 0 , S.OPRID FROM PS_IN_SDWC_INT_CTX P , PS_EOEN_DASHBRD D , PS_IN_DEMAND I , PS_SEC_BU_OPR S , PS_SEC_BU_OPR S1 WHERE %Join(COMMON_KEYS, IN_SDWC_SHP_CTX P, EOEN_DASHBRD D) AND D.EOEN_STATUS = '0' AND P.IN_PROCESS_DATE IS NOT NULL AND S.BUSINESS_UNIT = P.BUSINESS_UNIT AND S1.OPRID = S.OPRID AND S1.BUSINESS_UNIT = P.BUSINESS_UNIT AND I.BUSINESS_UNIT = P.BUSINESS_UNIT AND I.DEMAND_SOURCE = P.DEMAND_SOURCE AND I.SOURCE_BUS_UNIT = P.SOURCE_BUS_UNIT AND I.ORDER_NO = P.ORDER_NO AND I.ORDER_INT_LINE_NO = P.ORDER_INT_LINE_NO AND I.SCHED_LINE_NBR = P.SCHED_LINE_NBR AND I.INV_ITEM_ID = P.INV_ITEM_ID AND I.DEMAND_LINE_NO = P.DEMAND_LINE_NO AND %DatePart(I.SCHED_ARRV_DTTM) < %CurrentDateIn AND I.INTERUNIT_FLG = 'Y' AND I.INTERUNIT_STAT IN ('I','O','P') AND I.IN_FULFILL_STATE <= '60' AND I.IN_PROCESS_DATE IS NOT NULL UNION ALL SELECT %subrec(EOEN_LOG_KEY, PP) , %subrec(IN_SDWC_CTX_SBR, PP) , %subrec(IN_DMD_NKEY_SBR, PP) , %subrec(IN_SDWC_DMD_SBR, II) , %subrec(IN_SDWC_INT_SBR, II) , %DatePart(II.SCHED_ARRV_DTTM) , PP.IN_SDWC_HASH_KEY , DD.EOEN_STATUS , 0 , SS.OPRID FROM PS_IN_SDWC_INT_CTX PP , PS_EOEN_DASHBRD DD , PS_IN_DEMAND II , PS_SEC_BU_OPR SS , PS_SEC_BU_OPR SS1 WHERE %Join(COMMON_KEYS, IN_SDWC_SHP_CTX PP, EOEN_DASHBRD DD) AND DD.EOEN_STATUS = '0' AND PP.IN_PROCESS_DATE IS NULL AND SS.BUSINESS_UNIT = PP.BUSINESS_UNIT AND SS1.OPRID = SS.OPRID AND SS1.BUSINESS_UNIT = PP.BUSINESS_UNIT AND II.BUSINESS_UNIT = PP.BUSINESS_UNIT AND II.DEMAND_SOURCE = PP.DEMAND_SOURCE AND II.SOURCE_BUS_UNIT = PP.SOURCE_BUS_UNIT AND II.ORDER_NO = PP.ORDER_NO AND II.ORDER_INT_LINE_NO = PP.ORDER_INT_LINE_NO AND II.SCHED_LINE_NBR = PP.SCHED_LINE_NBR AND II.INV_ITEM_ID = PP.INV_ITEM_ID AND II.DEMAND_LINE_NO = PP.DEMAND_LINE_NO AND %DatePart(II.SCHED_ARRV_DTTM) < %CurrentDateIn AND II.INTERUNIT_FLG = 'Y' AND II.INTERUNIT_STAT IN ('I','O','P') AND II.IN_FULFILL_STATE = '70' AND II.IN_PROCESS_DATE IS NULL

# 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 EOEN_EMAIL_GROUP Number(10,0) DECIMAL(10) NOT NULL Email group id
5 EOEN_NOTIFY_TO Character(30) VARCHAR2(30) NOT NULL Notification receiver
6 EMAIL_ADDRESS Long Character CLOB Email Addresses
7 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
8 EOEN_LAST_DTTIME DateTime(26) TIMESTAMP Last Date Time
9 EOEN_EMAIL_SUBJECT Character(100) VARCHAR2(100) NOT NULL EOEN Email subject field
10 EOEC_UL_ID Character(30) VARCHAR2(30) NOT NULL Identifies the user list to be used when creating the approval process.
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

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

Prompt Table: SP_BU_FS_NONVW

14 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
15 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
16 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
17 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
18 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
19 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_ITEM

20 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
21 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
22 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
23 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: CUST_SHPINV_VW

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