In a SQL Window, when you right-click over an object name you get a context-sensitive popup menu. For a Package name I get a "Properties" menu entry. But this only shows me Package Spec info. How do I get the properties for the Package Body? The object browser is not a good option for an Oracle eBusiness Suite environment (too many packages).
How to get a Package Body's Properties
- Thread starter Gustavo
- Start date
I don't know if this helps, but you can filter the packages that appear in the object browser.
You can define a custom filter by clicking on the 5th icon from the left above the browser. A where-clause like "owner = 'SCOTT'" only shows those objects, and filters out all the system packages.
You can define a custom filter by clicking on the 5th icon from the left above the browser. A where-clause like "owner = 'SCOTT'" only shows those objects, and filters out all the system packages.
Not really. In Oracle eBusiness Suite there are schemas for each module (Inventory, Receivables, Payables, ...) but all of the Procedures, Functions and Packages are owned by APPS. For the most important modules the package count varies from 300 to 4100, so building filters per module wouldn't help either.
The package body is only accessible from the Object Browser, so you are restricted to browser filters for faster access.
Marco van der Linden
Member³
@Gustavo
If you create filters with 'object_name like 'INV%'' it will give you just what you need in 'a flash'. And I can't believe you're using more than 10 modules, so the number of filters will stay limited. (Receivables is a fun one thought, filter should be 'object_name like 'AR%' or object_name like 'RA%'').
If you create filters with 'object_name like 'INV%'' it will give you just what you need in 'a flash'. And I can't believe you're using more than 10 modules, so the number of filters will stay limited. (Receivables is a fun one thought, filter should be 'object_name like 'AR%' or object_name like 'RA%'').
@Marco Kalter - is it feasible to add an extra entry on the popup menu for packages (spec properties and body properties) ?
@Marco van der Linden - actualy, this can be a lot more complicated. Order Management goes through ONT, OE, WSH and QP. Costing is also spread: CST, INV, BOM and Brazilian Localization prefixes. And so on. I work mostly with Workflow, Inventory, Costing, Order Management, Purchasing and Human Resources. And I also give support to other modules. Not more than 10 modules, but more than 10 prefixes.
A menu entry would be so nice...
@Marco van der Linden - actualy, this can be a lot more complicated. Order Management goes through ONT, OE, WSH and QP. Costing is also spread: CST, INV, BOM and Brazilian Localization prefixes. And so on. I work mostly with Workflow, Inventory, Costing, Order Management, Purchasing and Human Resources. And I also give support to other modules. Not more than 10 modules, but more than 10 prefixes.
A menu entry would be so nice...
I have added this to the list of enhancement requests.
Similar threads
- Discussion
