DBA Data[Home] [Help]

APPS.EDW_GL_ACCT_M_C dependencies on EDW_LOCAL_EQUI_SET_OF_BOOKS

Line 295: FROM edw_local_equi_set_of_books)

291: select instance_code
292: from edw_local_instance )
293: AND edw_set_of_books_id NOT IN(
294: SELECT DISTINCT edw_set_of_books_id
295: FROM edw_local_equi_set_of_books)
296: ) B,
297: EDW_FLEX_SEG_MAPPINGS_V@' || G_TARGET_LINK || ' C
298: where C.DIMENSION_SHORT_NAME = ''' || g_dimension_name|| '''
299: AND lower(C.INSTANCE_CODE)= lower(B.INSTANCE)

Line 1218: FROM edw_local_equi_set_of_books

1214: from edw_local_instance
1215: )
1216: AND edw_set_of_books_id NOT IN(
1217: SELECT DISTINCT edw_set_of_books_id
1218: FROM edw_local_equi_set_of_books
1219: );
1220:
1221: l_temp_stmt varchar2(1000);
1222: l_source_link VARCHAR2(128);

Line 1395: FROM edw_local_equi_set_of_books

1391: FROM edw_local_set_of_books
1392: WHERE
1393: edw_set_of_books_id=(
1394: SELECT equi_set_of_books_id
1395: FROM edw_local_equi_set_of_books
1396: WHERE edw_set_of_books_id=l_parent_set_of_books.edw_set_of_books_id
1397: );
1398:
1399: FETCH cur_edw_equi_sob INTO l_edw_equi_sob;