1856: B.OBJECT_TYPE_NAME,
1857: C.OBJECT_NAME FOLDER_NAME,
1858: A.FOLDER_ID
1859: FROM BISM_OBJECTS A,
1860: BISM_OBJECT_TYPES B,
1861: BISM_OBJECTS C,
1862: (select C.CONTAINER_ID
1863: from BISM_OBJECTS C,
1864: BISM_OBJECT_TYPES D
1860: BISM_OBJECT_TYPES B,
1861: BISM_OBJECTS C,
1862: (select C.CONTAINER_ID
1863: from BISM_OBJECTS C,
1864: BISM_OBJECT_TYPES D
1865: where C.OBJECT_TYPE_ID = D.OBJECT_TYPE_ID
1866: and D.OBJECT_TYPE_NAME = 'Selection'
1867: and C.XML like p_search_str
1868: and C.FOLDER_ID IN
2370: B.OBJECT_TYPE_NAME,
2371: C.OBJECT_NAME FOLDER_NAME,
2372: A.FOLDER_ID
2373: FROM BISM_OBJECTS A,
2374: BISM_OBJECT_TYPES B,
2375: BISM_OBJECTS C,
2376: (select C.CONTAINER_ID
2377: from BISM_OBJECTS C,
2378: BISM_OBJECT_TYPES D
2374: BISM_OBJECT_TYPES B,
2375: BISM_OBJECTS C,
2376: (select C.CONTAINER_ID
2377: from BISM_OBJECTS C,
2378: BISM_OBJECT_TYPES D
2379: where C.OBJECT_TYPE_ID = D.OBJECT_TYPE_ID
2380: and D.OBJECT_TYPE_NAME = 'Selection'
2381: and C.XML like p_search_str
2382: and C.FOLDER_ID IN