I want to write a report of all packages and their associated functions and procedures, to do a count of lines.
pkg_a procedure_a 1,000
pkg_a procedure_b 888
pkg_a function_a 132
ALL_SOURCE gives me line counts but not parent relationships. ALL_OBJECTS
How can I get this parent child relationship? I can't see any relationships like through ALL_SOURCE or ALL_OBJECTS, just the objects themselves. Also looked at ALL_PROCEDURES and USER_IDENTIFIERS (no data).