eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_GL_ACCT_M_C dependencies on EDW_LOCAL_INSTANCE

Line 292: from edw_local_instance )

288: (SELECT distinct *
289: FROM edw_local_set_of_books
290: WHERE instance IN (
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,

Line 606: Select instance_code INTO l_ins_code FROM edw_local_instance;--added bug 3973264

602: l_ins_code varchar2(100);
603: begin
604:
605: --select instance.instance_name into l_ins_code from V$INSTANCE instance;
606: Select instance_code INTO l_ins_code FROM edw_local_instance;--added bug 3973264
607:
608: IF l_ins_code is not NULL then
609: VBHDEBUG('Source Instance code ' || l_ins_code );
610: return l_ins_code;

Line 628: l_stmt:= 'select instance.instance_code from edw_local_instance@'|| G_TARGET_LINK ||' instance';

624: begin
625: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
626: --l_stmt:= 'select instance.instance_name from V$INSTANCE@'|| G_TARGET_LINK ||' instance';
627: --added bug 3973264
628: l_stmt:= 'select instance.instance_code from edw_local_instance@'|| G_TARGET_LINK ||' instance';
629: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);
630: DBMS_SQL.define_column(l_cursor_id,1,l_ins_code, 255);
631: l_rows_queried := DBMS_SQL.execute(l_cursor_id);
632:

Line 1214: from edw_local_instance

1210: SELECT distinct *
1211: FROM edw_local_set_of_books
1212: WHERE instance IN (
1213: select instance_code
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

Line 1306: from edw_local_instance;

1302:
1303: begin
1304: select instance_code
1305: into g_instance_code
1306: from edw_local_instance;
1307: exception
1308: when no_data_found then
1309: edw_log.put_line( 'No data found in EDW_LOCAL_INSTANCE table.');
1310: return;

Line 1309: edw_log.put_line( 'No data found in EDW_LOCAL_INSTANCE table.');

1305: into g_instance_code
1306: from edw_local_instance;
1307: exception
1308: when no_data_found then
1309: edw_log.put_line( 'No data found in EDW_LOCAL_INSTANCE table.');
1310: return;
1311: when others then
1312: edw_log.put_line( 'Error: When looking up instance code in EDW_LOCAL_INSTANCE table.');
1313: return;

Line 1312: edw_log.put_line( 'Error: When looking up instance code in EDW_LOCAL_INSTANCE table.');

1308: when no_data_found then
1309: edw_log.put_line( 'No data found in EDW_LOCAL_INSTANCE table.');
1310: return;
1311: when others then
1312: edw_log.put_line( 'Error: When looking up instance code in EDW_LOCAL_INSTANCE table.');
1313: return;
1314: end;
1315:
1316: prepare_source_temp_table(l_source_temp_table_name, l_target_temp_table_name);