from where i can find activity name

Sort:
You are not authorized to post a reply.
Author
Messages
vijay
New Member
Posts: 1
New Member
    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
    Basic Member
      You can use the ACACTIVITY and ACACCTCAT tables to get the descriptions. Relate on ACTIVITY and ACCT-CATEGORY respectively.
      John Henley
      Senior Member
      Posts: 3348
      Senior Member
        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(+)
        Thanks for using the LawsonGuru.com forums!
        John
        You are not authorized to post a reply.