Hey, everyone. I’m looking for a way to get the table(s?) that an object references from the repository. I know I can view the SELECT statement from the repository, but isnt’ there a table somewhere with the IDs linked from UNV_OBJECT and UNV_TABLE?
Are you looking for UNV_OBJ_TAB, you should be able to query this stuff though Managero. Here is some code below that might help get you started, its just count of objects and associated table name (alias) or as an alternative although I am not entirely sure what you are trying to do maybe using the “full description” for Objects in the Print option tab in Designer will give you the table.column name of every object in a particuliar Universe.
SELECT
object_tables.TAB_NAME,
UNV_OBJECT.OBJ_NAME,
count(distinct UNV_OBJECT.OBJECT_ID)
FROM
UNV_TABLE object_tables,
UNV_OBJECT,
UNV_OBJ_TAB
WHERE
( UNV_OBJ_TAB.UNIVERSE_ID(+)=UNV_OBJECT.UNIVERSE_ID )
AND ( UNV_OBJ_TAB.OBJECT_ID(+)=UNV_OBJECT.OBJECT_ID )
AND ( object_tables.UNIVERSE_ID(+)=UNV_OBJ_TAB.UNIVERSE_ID )
AND ( object_tables.TABLE_ID(+)=UNV_OBJ_TAB.TABLE_ID )
GROUP BY
object_tables.TAB_NAME,
UNV_OBJECT.OBJ_NAME
Not the query above, you will probably want to pull in the name here is an example for a particuliar table:
SELECT
UNV_OBJECT.OBJ_NAME,
object_tables.TAB_NAME
FROM
UNV_OBJECT,
UNV_TABLE object_tables,
UNV_OBJ_TAB
WHERE
( UNV_OBJ_TAB.UNIVERSE_ID(+)=UNV_OBJECT.UNIVERSE_ID )
AND ( UNV_OBJ_TAB.OBJECT_ID(+)=UNV_OBJECT.OBJECT_ID )
AND ( object_tables.UNIVERSE_ID(+)=UNV_OBJ_TAB.UNIVERSE_ID )
AND ( object_tables.TABLE_ID(+)=UNV_OBJ_TAB.TABLE_ID )
AND (
object_tables.TAB_NAME = 'AGREEMENT'
)