APPS.BSC_UPDATE_VAL dependencies on BSC_DB_TABLES

Line 14: FROM bsc_db_tables_rels

10: ) RETURN BOOLEAN IS
11:
12: CURSOR c_base_tables (p_db_transform VARCHAR2) IS
13: SELECT DISTINCT table_name
14: FROM bsc_db_tables_rels
15: WHERE source_table_name IN (
16: SELECT table_name
17: FROM bsc_db_tables
18: WHERE table_type = 0

Line 17: FROM bsc_db_tables

13: SELECT DISTINCT table_name
14: FROM bsc_db_tables_rels
15: WHERE source_table_name IN (
16: SELECT table_name
17: FROM bsc_db_tables
18: WHERE table_type = 0
19: )
20: START WITH table_name IN (
21: SELECT table_name

Line 32: FROM bsc_db_tables_cols

28: CONNECT BY table_name = PRIOR source_table_name;
29:
30: CURSOR c_key_columns (p_table VARCHAR2, p_column_type VARCHAR2) IS
31: SELECT column_name
32: FROM bsc_db_tables_cols
33: WHERE table_name = p_table AND column_type = p_column_type;
34:
35:
36: h_db_transform VARCHAR2(20);

Line 101: FROM bsc_db_tables_rels

97: SELECT count(*)
98: INTO h_count
99: FROM (
100: SELECT source_table_name
101: FROM bsc_db_tables_rels
102: START WITH table_name IN (
103: SELECT table_name
104: FROM bsc_kpi_data_tables t, bsc_kpi_properties p
105: WHERE t.indicator = p.indicator AND

Line 136: ' FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d'||

132: TYPE t_cursor IS REF CURSOR;
133:
134: /* c_dim_cols t_cursor; -- x_input_table, h_column_type_p
135: c_dim_cols_sql VARCHAR2(2000) := 'SELECT t.column_name, d.level_view_name'||
136: ' FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d'||
137: ' WHERE t.table_name = :1 AND t.column_type = :2 AND'||
138: ' t.column_name = d.level_pk_col'; */
139:
140: cursor c_dim_cols( pTableName varchar2, pColTYpe varchar) is

Line 142: FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d

138: ' t.column_name = d.level_pk_col'; */
139:
140: cursor c_dim_cols( pTableName varchar2, pColTYpe varchar) is
141: SELECT t.column_name, d.level_view_name, d.short_name, d.source
142: FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d
143: WHERE t.table_name = pTableName
144: AND t.column_type = pColType
145: AND t.column_name = d.level_pk_col ;
146:

Line 149: h_column_name bsc_db_tables_cols.column_name%TYPE;

145: AND t.column_name = d.level_pk_col ;
146:
147: h_column_type_p VARCHAR2(1);
148:
149: h_column_name bsc_db_tables_cols.column_name%TYPE;
150: h_level_table_name bsc_sys_dim_levels_b.level_view_name%TYPE;
151: h_level_short_name bsc_sys_dim_levels_b.short_name%TYPE;
152: h_level_source bsc_sys_dim_levels_b.short_name%TYPE;
153: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;

Line 190: ' FROM bsc_db_tables_cols'||

186: ' r.dim_level_id = d1.dim_level_id AND'||
187: ' r.parent_dim_level_id = d2.dim_level_id AND'||
188: ' d1.level_pk_col in ('||
189: ' SELECT column_name'||
190: ' FROM bsc_db_tables_cols'||
191: ' WHERE table_name = :2 AND column_type = :3) AND'||
192: ' d2.level_pk_col in ('||
193: ' SELECT column_name'||
194: ' FROM bsc_db_tables_cols'||

Line 194: ' FROM bsc_db_tables_cols'||

190: ' FROM bsc_db_tables_cols'||
191: ' WHERE table_name = :2 AND column_type = :3) AND'||
192: ' d2.level_pk_col in ('||
193: ' SELECT column_name'||
194: ' FROM bsc_db_tables_cols'||
195: ' WHERE table_name = :4 AND column_type = :5)'; */
196:
197: cursor c_mn_rels(pRelnType number,pTableName varchar2, pColType varchar2,pTableName2 varchar2, pColType2 varchar2) is
198: SELECT d1.level_view_name as p1_table, d1.level_pk_col as p1_pk_col,

Line 210: FROM bsc_db_tables_cols

206: WHERE r.relation_col = r2.relation_col)
207: AND r.dim_level_id = d1.dim_level_id
208: AND r.parent_dim_level_id = d2.dim_level_id
209: AND d1.level_pk_col in ( SELECT column_name
210: FROM bsc_db_tables_cols
211: WHERE table_name = pTableName
212: AND column_type = pColType) AND
213: d2.level_pk_col in (
214: SELECT column_name

Line 215: FROM bsc_db_tables_cols

211: WHERE table_name = pTableName
212: AND column_type = pColType) AND
213: d2.level_pk_col in (
214: SELECT column_name
215: FROM bsc_db_tables_cols
216: WHERE table_name = pTableName2 AND column_type = pColType2);
217:
218:
219: h_p1_table bsc_sys_dim_levels_b.level_table_name%TYPE;

Line 220: h_p1_pk_col bsc_db_tables_cols.column_name%TYPE;

216: WHERE table_name = pTableName2 AND column_type = pColType2);
217:
218:
219: h_p1_table bsc_sys_dim_levels_b.level_table_name%TYPE;
220: h_p1_pk_col bsc_db_tables_cols.column_name%TYPE;
221: h_p2_table bsc_sys_dim_levels_b.level_table_name%TYPE;
222: h_p2_pk_col bsc_db_tables_cols.column_name%TYPE;
223: h_rel_table bsc_sys_dim_levels_b.level_table_name%TYPE;
224:

Line 222: h_p2_pk_col bsc_db_tables_cols.column_name%TYPE;

218:
219: h_p1_table bsc_sys_dim_levels_b.level_table_name%TYPE;
220: h_p1_pk_col bsc_db_tables_cols.column_name%TYPE;
221: h_p2_table bsc_sys_dim_levels_b.level_table_name%TYPE;
222: h_p2_pk_col bsc_db_tables_cols.column_name%TYPE;
223: h_rel_table bsc_sys_dim_levels_b.level_table_name%TYPE;
224:
225:
226: -- Bind Var. fix for POSCO