DBA Data[Home] [Help]

APPS.PJI_PJI_EXTRACTION_UTILS dependencies on BIS_OBJ_DEPENDENCY

Line 171: , BIS_OBJ_DEPENDENCY bod1

167: , decode(bod1.DEPEND_OBJECT_TYPE
168: , 'MV' , 1
169: , 0) ord_bod1
170: from DBA_REGISTERED_MVIEWS rmv
171: , BIS_OBJ_DEPENDENCY bod1
172: where 1=1
173: and rmv.NAME like 'PJI%'
174: and bod1.OBJECT_TYPE (+) = 'MV'
175: and rmv.NAME = bod1.OBJECT_NAME (+)

Line 177: , BIS_OBJ_DEPENDENCY bod2

173: and rmv.NAME like 'PJI%'
174: and bod1.OBJECT_TYPE (+) = 'MV'
175: and rmv.NAME = bod1.OBJECT_NAME (+)
176: ) level_1
177: , BIS_OBJ_DEPENDENCY bod2
178: WHERE 1=1
179: AND decode(level_1.ord_bod1
180: , 1, level_1.prnt1
181: , level_1.name ) = bod2.OBJECT_NAME (+)