VIEW: APPS.CN_TABLE_MAP_OBJECTS_V

Source

View Text - Preformatted

SELECT tmo.table_map_object_id, tmo.tm_object_type, tmo.table_map_id, tmo.object_id, obj.name, obj.object_value, obj.alias, obj.org_id FROM cn_table_map_objects tmo, cn_objects obj WHERE obj.object_id = tmo.object_id and obj.org_id = tmo.org_id

View Text - HTML Formatted

SELECT TMO.TABLE_MAP_OBJECT_ID
, TMO.TM_OBJECT_TYPE
, TMO.TABLE_MAP_ID
, TMO.OBJECT_ID
, OBJ.NAME
, OBJ.OBJECT_VALUE
, OBJ.ALIAS
, OBJ.ORG_ID
FROM CN_TABLE_MAP_OBJECTS TMO
, CN_OBJECTS OBJ
WHERE OBJ.OBJECT_ID = TMO.OBJECT_ID
AND OBJ.ORG_ID = TMO.ORG_ID