How to retrieve rules query from database?

• To retrive the Rule ID:

select * from wms_rules where name = 'Rule Name'

• To retrieve the exact name of package created by the rule:

select * from all_objects where object_name like '%RULE_ID%'  -- (Rule ID retrived from above query)

• By default the rule package name is

wms_rule_(RULE_ID)

For eg:

wms_rule_10045