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.BSC_MO_HELPER_PKG dependencies on BSC_TMP_BIG_IN_COND

Line 3048: DELETE FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = bsc_metadata_optimizer_pkg.g_session_id AND VARIABLE_ID = x_variable_id;

3044: l_error VARCHAR2(2000);
3045: BEGIN
3046:
3047:
3048: DELETE FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = bsc_metadata_optimizer_pkg.g_session_id AND VARIABLE_ID = x_variable_id;
3049:
3050: l_cond := x_column_name || ' IN (' ||
3051: ' SELECT VALUE_N FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = '||bsc_metadata_optimizer_pkg.g_session_id||
3052: ' AND VARIABLE_ID = ' || x_variable_id || ')';

Line 3051: ' SELECT VALUE_N FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = '||bsc_metadata_optimizer_pkg.g_session_id||

3047:
3048: DELETE FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = bsc_metadata_optimizer_pkg.g_session_id AND VARIABLE_ID = x_variable_id;
3049:
3050: l_cond := x_column_name || ' IN (' ||
3051: ' SELECT VALUE_N FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = '||bsc_metadata_optimizer_pkg.g_session_id||
3052: ' AND VARIABLE_ID = ' || x_variable_id || ')';
3053:
3054: return l_cond;
3055: EXCEPTION WHEN OTHERS THEN

Line 3068: INSERT INTO BSC_TMP_BIG_IN_COND(session_id, variable_id, value_n)

3064: IF (x_value.count=0) THEN
3065: return;
3066: END IF;
3067: FORALL i IN x_value.first..x_value.last
3068: INSERT INTO BSC_TMP_BIG_IN_COND(session_id, variable_id, value_n)
3069: VALUES
3070: (bsc_metadata_optimizer_pkg.g_session_id, x_variable_id, x_value(i));
3071: exception when others then
3072: writeTmp('exception in add_value_bulk for number table', FND_LOG.LEVEL_EXCEPTION, true);

Line 3083: INSERT INTO BSC_TMP_BIG_IN_COND(session_id, variable_id, value_v)

3079: IF (x_value.count=0) THEN
3080: return;
3081: END IF;
3082: FORALL i IN x_value.first..x_value.last
3083: INSERT INTO BSC_TMP_BIG_IN_COND(session_id, variable_id, value_v)
3084: VALUES
3085: (bsc_metadata_optimizer_pkg.g_session_id, x_variable_id, x_value(i));
3086: exception when others then
3087: writeTmp('exception in add_value_bulk for varchar2 table', FND_LOG.LEVEL_EXCEPTION, true);

Line 3124: DELETE FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = bsc_metadata_optimizer_pkg.g_session_id AND VARIABLE_ID = x_variable_id;

3120: l_stmt varchar2(300);
3121: cond varchar2(1000);
3122: l_error varchar2(1000);
3123: BEGIN
3124: DELETE FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = bsc_metadata_optimizer_pkg.g_session_id AND VARIABLE_ID = x_variable_id;
3125: cond := 'UPPER('|| x_column_name || ') IN ('||
3126: ' SELECT UPPER(VALUE_V) FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = '||bsc_metadata_optimizer_pkg.g_session_id
3127: ||' AND VARIABLE_ID = '||x_variable_id||')';
3128: return cond;

Line 3126: ' SELECT UPPER(VALUE_V) FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = '||bsc_metadata_optimizer_pkg.g_session_id

3122: l_error varchar2(1000);
3123: BEGIN
3124: DELETE FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = bsc_metadata_optimizer_pkg.g_session_id AND VARIABLE_ID = x_variable_id;
3125: cond := 'UPPER('|| x_column_name || ') IN ('||
3126: ' SELECT UPPER(VALUE_V) FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = '||bsc_metadata_optimizer_pkg.g_session_id
3127: ||' AND VARIABLE_ID = '||x_variable_id||')';
3128: return cond;
3129: EXCEPTION WHEN OTHERS THEN
3130: l_error := sqlerrm;

Line 4067: SELECT VALUE_V FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = bsc_metadata_optimizer_pkg.g_session_id

4063: CURSOR cStoITables IS
4064: select distinct source_table_name from bsc_db_tables_rels
4065: connect by table_name = prior source_table_name
4066: start with table_name in (
4067: SELECT VALUE_V FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = bsc_metadata_optimizer_pkg.g_session_id
4068: AND VARIABLE_ID = p_variable_id);
4069: lTable VARCHAR2(100);
4070: BEGIN
4071: OPEN cStoITables;

Line 6004: , bsc_tmp_big_in_cond cond

6000:
6001: l_stmt VARCHAR2(1000):=
6002: 'SELECT last.table_name, last.column_name
6003: FROM '||bsc_metadata_optimizer_pkg.g_db_tables_cols_last||' last
6004: , bsc_tmp_big_in_cond cond
6005: WHERE last.table_name = cond.value_v
6006: AND cond.variable_id = :1
6007: AND cond.session_id = :2
6008: AND last.column_type = :3

Line 6013: , bsc_tmp_big_in_cond cond

6009: MINUS
6010: SELECT cols.table_name, cols.column_name
6011: FROM bsc_db_tables_cols cols
6012: , bsc_db_tables_rels rels
6013: , bsc_tmp_big_in_cond cond
6014: WHERE cond.value_v = rels.source_table_name
6015: AND rels.table_name = cols.table_name
6016: AND cond.variable_id = :4
6017: AND cond.session_id = :5

Line 6065: start with table_name in (select value_v from bsc_tmp_big_in_cond where variable_id=:1 and session_id=:2)';

6061: cv CurTyp;
6062: l_stmt VARCHAR2(1000):=
6063: 'select distinct source_table_name from '||BSC_METADATA_OPTIMIZER_PKG.g_db_table_rels_last||'
6064: connect by table_name = prior source_table_name
6065: start with table_name in (select value_v from bsc_tmp_big_in_cond where variable_id=:1 and session_id=:2)';
6066: l_unused_columns DBMS_SQL.VARCHAR2_TABLE;
6067: l_mvlog_name VARCHAR2(100);
6068: l_source_table_name VARCHAR2(100);
6069: l_i_table DBMS_SQL.VARCHAR2_TABLE;

Line 6301: select upper(value_v) from bsc_tmp_big_in_cond where variable_id=:2 and session_id = :3';

6297: strWhereInCondition || ')';
6298:
6299: l_stmt := 'SELECT DISTINCT TABLE_NAME FROM BSC_DB_TABLES WHERE TABLE_TYPE <> :1
6300: minus
6301: select upper(value_v) from bsc_tmp_big_in_cond where variable_id=:2 and session_id = :3';
6302: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
6303: BSC_MO_HELPER_PKG.writeTmp('l_stmt = '||l_stmt||' '||get_time);
6304: END IF;
6305: