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_UPDATE dependencies on BSC_DB_TABLES

Line 92: ' FROM bsc_db_tables_rels'||

88:
89: /*
90: c_origin_tables t_cursor; -- x_system_table
91: c_origin_tables_sql VARCHAR2(2000) := 'SELECT source_table_name'||
92: ' FROM bsc_db_tables_rels'||
93: ' WHERE table_name = :1';
94: */
95: CURSOR c_origin_tables (p_table_name VARCHAR2) IS
96: SELECT source_table_name

Line 97: FROM bsc_db_tables_rels

93: ' WHERE table_name = :1';
94: */
95: CURSOR c_origin_tables (p_table_name VARCHAR2) IS
96: SELECT source_table_name
97: FROM bsc_db_tables_rels
98: WHERE table_name = p_table_name;
99:
100: h_origin_table bsc_db_tables_rels.source_table_name%TYPE;
101: h_ret BOOLEAN;

Line 100: h_origin_table bsc_db_tables_rels.source_table_name%TYPE;

96: SELECT source_table_name
97: FROM bsc_db_tables_rels
98: WHERE table_name = p_table_name;
99:
100: h_origin_table bsc_db_tables_rels.source_table_name%TYPE;
101: h_ret BOOLEAN;
102:
103: BEGIN
104: h_ret := TRUE;

Line 200: 'FROM bsc_db_tables '||

196: BSC_APPS.Add_Value_Big_In_Cond(1, h_system_tables(h_i));
197: END LOOP;
198:
199: h_sql := 'SELECT DISTINCT periodicity_id '||
200: 'FROM bsc_db_tables '||
201: 'WHERE '||h_lst_where;
202:
203: OPEN h_cursor FOR h_sql;
204: FETCH h_cursor INTO h_periodicity_id;

Line 279: FROM bsc_db_tables_cols

275:
276: CURSOR h_cursor (p_table_type NUMBER, p_column_type VARCHAR2, p_indic_type NUMBER,
277: p_config_type NUMBER, p_dim_level_index NUMBER) IS
278: SELECT table_name, column_name
279: FROM bsc_db_tables_cols
280: WHERE table_name IN (
281: SELECT table_name
282: FROM bsc_db_tables_rels
283: WHERE source_table_name IN (

Line 282: FROM bsc_db_tables_rels

278: SELECT table_name, column_name
279: FROM bsc_db_tables_cols
280: WHERE table_name IN (
281: SELECT table_name
282: FROM bsc_db_tables_rels
283: WHERE source_table_name IN (
284: SELECT table_name
285: FROM bsc_db_tables
286: WHERE table_type = p_table_type

Line 285: FROM bsc_db_tables

281: SELECT table_name
282: FROM bsc_db_tables_rels
283: WHERE source_table_name IN (
284: SELECT table_name
285: FROM bsc_db_tables
286: WHERE table_type = p_table_type
287: )
288: ) AND
289: column_type = p_column_type AND

Line 1018: FROM bsc_db_tables t, bsc_sys_periodicities p

1014:
1015: -- Fix perf bug#4924515 use bsc_sys_periodicities instead of bsc_sys_periodicities_vl
1016: CURSOR c_tables (p_table_type NUMBER, p_calendar_id NUMBER) IS
1017: SELECT t.table_name, t.periodicity_id, t.current_period, p.yearly_flag
1018: FROM bsc_db_tables t, bsc_sys_periodicities p
1019: WHERE t.periodicity_id = p.periodicity_id AND
1020: t.table_type = p_table_type AND p.calendar_id = p_calendar_id;
1021:
1022: CURSOR c_base_tables_mv (p_table_type1 NUMBER, p_gen_type NUMBER,

Line 1025: FROM bsc_db_tables t, bsc_sys_periodicities p

1021:
1022: CURSOR c_base_tables_mv (p_table_type1 NUMBER, p_gen_type NUMBER,
1023: p_calendar_id NUMBER, p_table_type0 NUMBER) IS
1024: SELECT t.table_name, t.periodicity_id, t.current_period, p.yearly_flag
1025: FROM bsc_db_tables t, bsc_sys_periodicities p
1026: WHERE t.periodicity_id = p.periodicity_id AND
1027: t.table_type = p_table_type1 AND t.generation_type <> p_gen_type AND
1028: p.calendar_id = p_calendar_id AND
1029: t.table_name IN (

Line 1031: FROM bsc_db_tables_rels r, bsc_db_tables b

1027: t.table_type = p_table_type1 AND t.generation_type <> p_gen_type AND
1028: p.calendar_id = p_calendar_id AND
1029: t.table_name IN (
1030: SELECT r.table_name
1031: FROM bsc_db_tables_rels r, bsc_db_tables b
1032: WHERE r.source_table_name = b.table_name and b.table_type = p_table_type0
1033: );
1034:
1035: -- BSC-BIS-DIMENSION: I am fixing this query. We should return the PT tables, that are the

Line 1041: FROM bsc_db_tables t, bsc_sys_periodicities_vl p

1037: /*
1038: CURSOR c_sum_tables_mv (p_table_type1 NUMBER, p_gen_type NUMBER,
1039: p_calendar_id NUMBER, p_table_type0 NUMBER) IS
1040: SELECT t.table_name, t.periodicity_id, t.current_period, p.yearly_flag
1041: FROM bsc_db_tables t, bsc_sys_periodicities_vl p
1042: WHERE t.periodicity_id = p.periodicity_id AND
1043: t.table_type = p_table_type1 AND t.generation_type <> p_gen_type AND
1044: p.calendar_id = p_calendar_id AND
1045: NOT (t.table_name IN (

Line 1047: FROM bsc_db_tables_rels r, bsc_db_tables b

1043: t.table_type = p_table_type1 AND t.generation_type <> p_gen_type AND
1044: p.calendar_id = p_calendar_id AND
1045: NOT (t.table_name IN (
1046: SELECT r.table_name
1047: FROM bsc_db_tables_rels r, bsc_db_tables b
1048: WHERE r.source_table_name = b.table_name and b.table_type = p_table_type0
1049: ));
1050: */
1051: --Fix perf bug#4924515 use bsc_sys_periodicities instead of bsc_sys_periodicities_vl

Line 1067: table_name bsc_db_tables.table_name%TYPE,

1063: WHERE c.table_name = p_table_name AND c.calculation_type = p_calc_type AND
1064: c.parameter1 = p.periodicity_id;
1065:
1066: TYPE t_tables IS RECORD (
1067: table_name bsc_db_tables.table_name%TYPE,
1068: periodicity_id bsc_db_tables.periodicity_id%TYPE,
1069: current_period bsc_db_tables.current_period%TYPE,
1070: yearly_flag bsc_sys_periodicities_vl.yearly_flag%TYPE
1071: );

Line 1068: periodicity_id bsc_db_tables.periodicity_id%TYPE,

1064: c.parameter1 = p.periodicity_id;
1065:
1066: TYPE t_tables IS RECORD (
1067: table_name bsc_db_tables.table_name%TYPE,
1068: periodicity_id bsc_db_tables.periodicity_id%TYPE,
1069: current_period bsc_db_tables.current_period%TYPE,
1070: yearly_flag bsc_sys_periodicities_vl.yearly_flag%TYPE
1071: );
1072:

Line 1069: current_period bsc_db_tables.current_period%TYPE,

1065:
1066: TYPE t_tables IS RECORD (
1067: table_name bsc_db_tables.table_name%TYPE,
1068: periodicity_id bsc_db_tables.periodicity_id%TYPE,
1069: current_period bsc_db_tables.current_period%TYPE,
1070: yearly_flag bsc_sys_periodicities_vl.yearly_flag%TYPE
1071: );
1072:
1073: h_table_info t_tables;

Line 1425: bsc_db_tables

1421:
1422: -- Update the current period of data tables
1423: -- Fix perf bug#4924515 use bsc_sys_periodiicties instead of bsc_sys_periodicities_vl
1424: UPDATE
1425: bsc_db_tables
1426: SET
1427: current_period = h_current_fy + 1,
1428: current_subperiod = 0
1429: WHERE

Line 1442: bsc_db_tables

1438: yearly_flag = 1);
1439:
1440:
1441: UPDATE
1442: bsc_db_tables
1443: SET
1444: current_period = 1,
1445: current_subperiod = 0
1446: WHERE

Line 1730: ' FROM bsc_db_tables_rels'||

1726:
1727: /*
1728: c_base_table t_cursor; -- x_input_table, 0
1729: c_base_table_sql VARCHAR2(2000) := 'SELECT table_name'||
1730: ' FROM bsc_db_tables_rels'||
1731: ' WHERE UPPER(source_table_name) = UPPER(:1) AND relation_type = :2';
1732: */
1733:
1734: BEGIN

Line 1747: FROM bsc_db_tables_rels

1743:
1744: BEGIN
1745: SELECT table_name
1746: INTO x_base_table
1747: FROM bsc_db_tables_rels
1748: WHERE UPPER(source_table_name) = UPPER(x_input_table) AND relation_type = 0;
1749: EXCEPTION
1750: WHEN NO_DATA_FOUND THEN
1751: x_base_table := NULL;

Line 1781: ' FROM bsc_db_tables_cols c, bsc_db_loader_control p'||

1777: c_edw_dimensions_sql VARCHAR2(2000) := 'SELECT level_table_name'||
1778: ' FROM bsc_sys_dim_levels_b'||
1779: ' WHERE NVL(edw_flag, 0) = :1 AND'||
1780: ' level_pk_col IN (SELECT column_name'||
1781: ' FROM bsc_db_tables_cols c, bsc_db_loader_control p'||
1782: ' WHERE c.table_name = p.input_table_name AND'||
1783: ' c.column_type = :2 AND p.process_id = :3 AND p.status = :4)';
1784: */
1785: CURSOR c_edw_dimensions (p_edw_flag NUMBER, p_column_type VARCHAR2, p_process_id NUMBER, p_status VARCHAR2) IS

Line 1791: FROM bsc_db_tables_cols c, bsc_db_loader_control p

1787: FROM bsc_sys_dim_levels_b
1788: WHERE NVL(edw_flag, 0) = p_edw_flag AND
1789: level_pk_col IN (
1790: SELECT column_name
1791: FROM bsc_db_tables_cols c, bsc_db_loader_control p
1792: WHERE c.table_name = p.input_table_name AND
1793: c.column_type = p_column_type AND p.process_id = p_process_id AND p.status = p_status);
1794:
1795: h_column_type_p VARCHAR2(1);

Line 2060: INPUT_TABLE_NAME IN (SELECT TABLE_NAME FROM BSC_DB_TABLES WHERE TABLE_TYPE = 0);

2056: FROM
2057: BSC_DB_LOADER_CONTROL
2058: WHERE
2059: PROCESS_ID = x_process_id AND
2060: INPUT_TABLE_NAME IN (SELECT TABLE_NAME FROM BSC_DB_TABLES WHERE TABLE_TYPE = 0);
2061: END IF;
2062:
2063: IF x_process_name = PC_LOAD_DIMENSIONS THEN
2064: -- Associate same input tables to new process

Line 2085: INPUT_TABLE_NAME IN (SELECT TABLE_NAME FROM BSC_DB_TABLES WHERE TABLE_TYPE = 2);

2081: FROM
2082: BSC_DB_LOADER_CONTROL
2083: WHERE
2084: PROCESS_ID = x_process_id AND
2085: INPUT_TABLE_NAME IN (SELECT TABLE_NAME FROM BSC_DB_TABLES WHERE TABLE_TYPE = 2);
2086: END IF;
2087:
2088: COMMIT;
2089:

Line 2415: FROM bsc_db_tables_rels

2411: --h_cursor t_cursor;
2412:
2413: CURSOR c_tables (p_source_table_name VARCHAR2) IS
2414: SELECT table_name
2415: FROM bsc_db_tables_rels
2416: WHERE source_table_name = p_source_table_name;
2417:
2418: h_new_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
2419: h_num_new_tables NUMBER;

Line 2433: ' FROM bsc_db_tables_rels'||

2429:
2430: FOR h_i IN 1 .. x_num_tables LOOP
2431: /*
2432: h_sql := 'SELECT table_name'||
2433: ' FROM bsc_db_tables_rels'||
2434: ' WHERE source_table_name = :1';
2435: --OPEN h_cursor FOR h_sql USING x_tables(h_i);
2436: */
2437: OPEN c_tables(x_tables(h_i));

Line 5614: cursor c1(p_table varchar2) is select table_name from bsc_db_tables_rels where source_table_name=p_table;

5610: x_indicators IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number,
5611: x_num_indicators IN OUT NOCOPY NUMBER
5612: )return boolean is
5613: --
5614: cursor c1(p_table varchar2) is select table_name from bsc_db_tables_rels where source_table_name=p_table;
5615: --
5616: cursor c2(p_table varchar2) is select distinct indicator from bsc_kpi_data_tables where table_name=p_table;
5617: --
5618: l_tables BSC_UPDATE_UTIL.t_array_of_varchar2;

Line 5704: ' FROM bsc_kpi_dim_levels_vl k, bsc_db_tables_rels r'||

5700: BSC_APPS.Add_Value_Big_In_Cond(1, x_indicators(h_i));
5701: END LOOP;
5702:
5703: h_sql := 'SELECT DISTINCT source_table_name'||
5704: ' FROM bsc_kpi_dim_levels_vl k, bsc_db_tables_rels r'||
5705: ' WHERE ('||h_where_indics||') AND k.level_source = :1 '||
5706: ' AND k.level_table_name = r.table_name';
5707:
5708: OPEN h_cursor FOR h_sql USING h_source;

Line 5720: ' FROM bsc_kpi_dim_levels_vl k, bsc_db_tables_rels r'||

5716: CLOSE h_cursor;
5717:
5718: -- Also include Input tables for MN dimensions
5719: h_sql := 'SELECT DISTINCT source_table_name'||
5720: ' FROM bsc_kpi_dim_levels_vl k, bsc_db_tables_rels r'||
5721: ' WHERE ('||h_where_indics||') AND k.level_source = :1 '||
5722: ' AND k.table_relation = r.table_name';
5723:
5724: OPEN h_cursor FOR h_sql USING h_source;

Line 5836: bsc_db_tables t

5832: SELECT DISTINCT
5833: NVL(MIN(t.current_period), p.current_period)
5834: FROM
5835: bsc_kpi_data_tables k,
5836: bsc_db_tables t
5837: WHERE
5838: k.table_name = t.table_name AND
5839: k.indicator = p.indicator AND
5840: t.periodicity_id = p.periodicity_id)

Line 5871: bsc_db_tables t

5867: SELECT DISTINCT
5868: NVL(MIN(t.current_period), p.current_period)
5869: FROM
5870: bsc_kpi_data_tables k,
5871: bsc_db_tables t
5872: WHERE
5873: k.table_name = t.table_name AND
5874: k.indicator = p.indicator AND
5875: t.periodicity_id = p.periodicity_id)

Line 6118: ' FROM bsc_db_tables'||

6114: c_invalid_codes_sql VARCHAR2(2000) := 'SELECT input_table_name, column_name, invalid_code'||
6115: ' FROM bsc_db_validation'||
6116: ' WHERE input_table_name IN ('||
6117: ' SELECT table_name'||
6118: ' FROM bsc_db_tables'||
6119: ' WHERE table_type = DECODE(:1, :2, :3, :4))'||
6120: ' ORDER BY input_table_name';
6121: */
6122: --Fix bug#4581846: show invalid codes for input tables involved in this process only

Line 6140: ' FROM bsc_db_tables t, bsc_db_loader_control lc, bsc_sys_periodicities_vl p'||

6136: /*
6137: c_tables t_cursor; -- g_process_id
6138: c_tables_sql VARCHAR2(2000) := 'SELECT lc.input_table_name, t.periodicity_id,'||
6139: ' p.name, t.current_period, t.current_subperiod'||
6140: ' FROM bsc_db_tables t, bsc_db_loader_control lc, bsc_sys_periodicities_vl p'||
6141: ' WHERE lc.input_table_name = t.table_name AND'||
6142: ' lc.process_id = :1 AND t.periodicity_id = p.periodicity_id';
6143: */
6144: CURSOR c_tables (p_process_id NUMBER) IS

Line 6147: FROM bsc_db_tables t, bsc_db_loader_control lc, bsc_sys_periodicities_vl p

6143: */
6144: CURSOR c_tables (p_process_id NUMBER) IS
6145: SELECT lc.input_table_name, t.periodicity_id,
6146: p.name, t.current_period, t.current_subperiod
6147: FROM bsc_db_tables t, bsc_db_loader_control lc, bsc_sys_periodicities_vl p
6148: WHERE lc.input_table_name = t.table_name AND
6149: lc.process_id = p_process_id AND t.periodicity_id = p.periodicity_id;
6150:
6151: h_periodicity_id NUMBER;