Who's On?

	Membership:
	Latest: cat andrews
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5215

	People Online:
	Visitors: 271
	Members: 0
	Total: 271

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

from where i can find activity name

2 Replies

0 Subscribed to this topic

23 Subscribed to this forum

Sort:

Author

Messages

vijay

New Member

Posts: 0

11/16/2005 10:50 AM

i am using table mmdist table for details.But as it having only activity code and accounting_category code.,But i also wants activity name and accounting category name also in my report.
Inwhich table i canget them and how i can relate them to mmdist

Keri White

Basic Member

Posts: 6

12/14/2005 10:30 PM

You can use the ACACTIVITY and ACACCTCAT tables to get the descriptions. Relate on ACTIVITY and ACCT-CATEGORY respectively.

John Henley

Posts: 3364

New Poster

Engaged Reader

Avid Reader

12/14/2005 10:45 PM

In (Oracle) SQL, it would look something like this:
SELECT
MMD.ACTIVITY,
ACV.DESCRIPTION,
MMD.ACCT_CATEGORY,
AAX.DESCRIPTION
FROM
MMDIST MMD,
ACACTIVITY ACV,
ACACCTCAT AAX
WHERE
MMD.ACTIVITY=ACV.ACTIVITY(+)
AND
MMD.ACCT_CATEGORY=AAX.ACCT_CATEGORY(+)