Need Order number from approval group

Dear,

In the below query, i need to add one more column which is order number from the approval group, any body have idea.

SELECT *

  FROM (SELECT AmeActionUsageEO.rule_id,

               AmeActionUsageEO.action_id,

               AmeActionUsageEO.object_version_number,

               AmeActionUsageEO.start_date,

               AmeActionUsageEO.end_date,

               aty.name AS "ACTION_TYPE_NAME",

               ame_utility_pkg.

               get_action_description (AmeActionUsageEO.action_id)

                  AS "ACTION",

               aty.action_type_id,

               'Y' AS "CASE1",

               'A' AS "CASE2",

               atu.rule_type AS RULE_TYPE,

               aty.USER_ACTION_TYPE_NAME AS USER_ACTION_TYPE_NAME

          FROM ame_action_usages AmeActionUsageEO,

               ame_actions_vl act,

               ame_action_types_vl aty,