DBA Data[Home] [Help]

APPS.BISM_WEAKAGGREGATES dependencies on BISM_AGGREGATES

Line 264: select distinct containee_id,container_id,aggregate_info from bism_aggregates start with containee_id = objid and container_id='30' connect by container_id = prior containee_id

260: A.KEYWORDS, A.XML, A.APPLICATION_SUBTYPE1, A.COMP_SUBTYPE1, A.COMP_SUBTYPE2,A.COMP_SUBTYPE3, A.TIME_DATE_LAST_ACCESSED,
261: T1.container_id,T1.aggregate_info
262: from bism_objects A,
263: (
264: select distinct containee_id,container_id,aggregate_info from bism_aggregates start with containee_id = objid and container_id='30' connect by container_id = prior containee_id
265: order siblings by containee_id
266: )
267: T1
268: where A.object_id=T1.containee_id