WM_RPT_NOTE_HDR

(SQL View)

SELECT R.OPRID , R.RUN_CNTL_ID , R.PROCESS_INSTANCE , R.BUSINESS_UNIT , C.WO_ID , C.WO_TASK_ID , N.SEQ_NBR_5 , N.TITLE , N.NOTES FROM PS_WM_WOE_RPT_REQ R , PS_WM_WOE_RPT_CRIT C , PS_WM_TSK_NOTES N WHERE %Join(COMMON_KEYS, WM_WOE_RPT_REQ R , WM_WOE_RPT_CRIT C) AND %Join(COMMON_KEYS, WM_WOE_RPT_CRIT C , WM_TSK_NOTES N)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Default Value: WM_WOE_WB_VW.OPRID
Prompt Table: OPRID_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_WM_NONVW

5 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

6 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

7 SEQ_NBR_5 Number(5,0) INTEGER NOT NULL Sequence number five digits long

8 TITLE Character(35) VARCHAR2(35) NOT NULL Title

9 NOTES Long Character CLOB Budget Notes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: WM_WOE_WB_VW.OPRID Prompt Table: OPRID_VW
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_WM_NONVW
5	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification
6	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number
7	SEQ_NBR_5	Number(5,0)	INTEGER NOT NULL	Sequence number five digits long
8	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
9	NOTES	Long Character	CLOB	Budget Notes