DBA Data[Home] [Help]

APPS.BSC_MO_LOADER_CONFIG_PKG dependencies on BSC_TMP_BIG_IN_COND

Line 690: select value_v from bsc_tmp_big_in_cond

686: select table_name from bsc_db_Tables_rels
687: connect by source_table_name = prior table_name
688: start with source_table_name in
689: (
690: select value_v from bsc_tmp_big_in_cond
691: where variable_id=10
692: and session_id = userenv('SESSIONID')
693: )
694: union -- add deleted periodicities

Line 698: from bsc_tmp_big_in_cond

694: union -- add deleted periodicities
695: select table_name from bsc_db_tables_rels
696: where substr(table_name, 1, instr(table_name, '_', -1)) in
697: (select substr(value_v, 1, instr(value_v, '_', -1))
698: from bsc_tmp_big_in_cond
699: where variable_id = 10
700: and session_id=userenv('SESSIONID')
701: )
702: ;