CM_DRILL_PRI_VW (SQL View)	Index Back
Drilldown mg_proc inst prompt Drilldown mg process intance prompt 10/15/99 ej Add DISTINCT in SQL; change BU as a search key

CM_DRILL_PRI_VW

(SQL View)

Drilldown mg_proc inst prompt

Drilldown mg process intance prompt 10/15/99 ej Add DISTINCT in SQL; change BU as a search key

SELECT DISTINCT A.BUSINESS_UNIT , A.MG_PROC_INSTANCE FROM PS_CM_ACCTG_LINE A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 MG_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	MG_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance