IN_SDWC_RPAR_VW (SQL View)	Index Back
Demand on hold view No security

IN_SDWC_RPAR_VW

(SQL View)

Demand on hold view

No security

SELECT %subrec(EOEN_LOG_KEY, P) , %subrec(IN_SDWC_CTX_SBR, P) , P.IN_SDWC_DOC_TYPE , %subrec(IN_DMD_NKEY_SBR, P) , ' ' , 0 , ' ' , ' ' , ' ' , ' ' , 0 , D.LOCATION , %DateNull , %DateTimeNull , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , 'N' , D.QTY_REQ , D.QTY_REQ_STD , L.UNIT_OF_MEASURE , 0 , 0 , 0 , D.MERCHANDISE_AMT , D.MERCH_AMT_BSE , D.CURRENCY_CD , D.CURRENCY_CD_BASE , ' ' , ' ' , C.CART_GROUP , D.DISTRIB_LINE_NUM , D.DISTRIB_LN_STATUS , D.PEG_STATUS , ' ' , L.VENDOR_ID , L.VNDR_LOC , V.NAME1 , S.DUE_DT , CASE WHEN H.REQ_STATUS = 'D' THEN 'DA' ELSE H.REQ_STATUS END , ' ' , ' ' , 0 , 0 , 0 , C.INV_CART_ID , C.ORDER_BU , C.SHIPTO_ID , P.ORDER_NO , E.EOEN_STATUS , 0 FROM PS_IN_SDWC_PAR_CTX P , PS_EOEN_DASHBRD E , PS_REQ_LN_DISTRIB D , PS_REQ_LINE_SHIP S , PS_REQ_LINE L , PS_REQ_HDR H , PS_CART_ATTRIB_INV C , PS_VENDOR V WHERE %Join(COMMON_KEYS, IN_SDWC_PAR_CTX P, EOEN_DASHBRD E) AND E.EOEN_STATUS = '0' AND P.IN_PROCESS_DATE IS NOT NULL AND P.IN_SDWC_DOC_TYPE = '10' AND P.DEMAND_SOURCE = 'RQ' AND S.BUSINESS_UNIT = P.SOURCE_BUS_UNIT AND S.REQ_ID = P.ORDER_NO AND S.LINE_NBR = P.ORDER_INT_LINE_NO AND S.SCHED_NBR = P.SCHED_LINE_NBR AND L.INV_ITEM_ID = P.INV_ITEM_ID AND V.SETID = L.VENDOR_SETID AND V.VENDOR_ID = L.VENDOR_ID AND %Join(COMMON_KEYS, REQ_LINE L, REQ_HDR H) AND %Join(COMMON_KEYS, REQ_LINE_SHIP S, REQ_LINE L) AND %Join(COMMON_KEYS, REQ_LN_DISTRIB D, REQ_LINE_SHIP S) AND D.DISTRIB_LN_STATUS IN ('C','O','P','X') AND S.DUE_DT < %CurrentDateIn AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.BUSINESS_UNIT_PO = D.BUSINESS_UNIT AND C.INV_CART_ID = D.LOCATION

# 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 IN_SDWC_DOC_TYPE Character(2) VARCHAR2(2) NOT NULL Document Type
00=MSR
10=Requisition
20=Purchase Order

12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUIN_NONVW

13 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

14 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
Prompt Table: SP_BU_FS_NONVW

15 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

16 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

17 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

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

19 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

20 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

21 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority

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

23 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id

24 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

25 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name

26 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

27 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

28 SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date

29 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added

30 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

31 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

32 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

33 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

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 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes

37 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested

38 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base

39 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

40 TOTAL_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Quantity

41 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped

42 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base

43 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

44 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount

45 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

46 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

47 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes

48 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit

49 CART_GROUP Character(5) VARCHAR2(5) NOT NULL Par Location Group

50 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

51 DISTRIB_LN_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Line Status
C=Closed
M=Mass Liquidated
O=Open
P=Unavailable for Sourcing
X=Canceled

52 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged

53 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

54 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

55 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

56 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

57 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

58 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Req status
A=Approved
C=Complete
D=Denied
I=Initial
LA=Line Approved
O=Open
P=Pending Approval
V=Preview
X=Canceled

59 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled

60 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

61 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number

62 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number

63 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number

64 INV_CART_ID Character(15) VARCHAR2(15) NOT NULL Par Location ID

65 ORDER_BU Character(5) VARCHAR2(5) NOT NULL Par Loc Order Business Unit

66 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

67 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document

68 EOEN_STATUS Character(1) VARCHAR2(1) NOT NULL EOEN Status
0=Open
1=Closed

69 ROWNBR Number(7,0) INTEGER NOT NULL Row number

#	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	IN_SDWC_DOC_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Document Type 00=MSR 10=Requisition 20=Purchase Order
12	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUIN_NONVW
13	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
14	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit Prompt Table: SP_BU_FS_NONVW
15	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
16	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
17	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
18	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
19	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
20	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
21	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
22	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
23	PARENT_PROD_ID	Character(18)	VARCHAR2(18) NOT NULL	Parent Product Id
24	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
25	SHIP_CUST_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Ship To Name
26	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
27	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
28	SCHED_SHIP_DATE	Date(10)	DATE	Scheduled Ship Date
29	SCHED_DTTM	DateTime(26)	TIMESTAMP	08/16/01 JNW (CN#PL900-1.0): Added
30	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
31	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
32	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
33	LOAD_ID	Character(10)	VARCHAR2(10) NOT NULL	Load ID
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	SINGLE_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Single Ship Flag N=No Y=Yes
37	QTY_REQUESTED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested
38	QTY_REQUESTED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested Base
39	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
40	TOTAL_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Total Quantity
41	QTY_SHIPPED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Shipped
42	QTY_SHIP_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Ship Base
43	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
44	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
45	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
46	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
47	INTERUNIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	InterUnit N=No Y=Yes
48	DESTIN_BU	Character(5)	VARCHAR2(5) NOT NULL	Destination Unit
49	CART_GROUP	Character(5)	VARCHAR2(5) NOT NULL	Par Location Group
50	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
51	DISTRIB_LN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Line Status C=Closed M=Mass Liquidated O=Open P=Unavailable for Sourcing X=Canceled
52	PEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	07/21/04 EGS: Created 10=Open 20=Completed 30=Canceled 40=Not Pegged
53	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
54	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
55	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
56	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
57	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
58	REQ_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Req status A=Approved C=Complete D=Denied I=Initial LA=Line Approved O=Open P=Pending Approval V=Preview X=Canceled
59	PO_STATUS	Character(2)	VARCHAR2(2) NOT NULL	PO Status A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled
60	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
61	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
62	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
63	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
64	INV_CART_ID	Character(15)	VARCHAR2(15) NOT NULL	Par Location ID
65	ORDER_BU	Character(5)	VARCHAR2(5) NOT NULL	Par Loc Order Business Unit
66	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
67	DOCUMENT_ID	Character(12)	VARCHAR2(12) NOT NULL	Document
68	EOEN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	EOEN Status 0=Open 1=Closed
69	ROWNBR	Number(7,0)	INTEGER NOT NULL	Row number