APPS.EDW_NAEDW_PUSH dependencies on EDW_DIMENSIONS_MD_V

Line 9: from edw_dimensions_md_v dim

5:
6: cursor c0 is
7: select dim.dim_name,
8: dim.dim_id
9: from edw_dimensions_md_v dim
10: where dim_name not like 'EDW_GL_ACCT%_M'
11: and dim_name <> 'EDW_NA'
12: order by dim.dim_name;
13:

Line 17: edw_dimensions_md_v dim

13:
14: cursor c0_0(p_dim varchar2) is
15: select dim.dim_name,dim.dim_id
16: from
17: edw_dimensions_md_v dim
18: where dim_long_name=p_dim;
19:
20: cursor c00(p_dim_id number) is
21: select level_name||'_LTC'

Line 335: l_stmt:='select dim_name,dim_id from edw_dimensions_md_v where dim_long_name=:s';

331: g_number_dims:=1;
332: g_dim_name(g_number_dims):=null;
333: g_dim_id(g_number_dims):=null;
334: if p_type='LONGNAME' then
335: l_stmt:='select dim_name,dim_id from edw_dimensions_md_v where dim_long_name=:s';
336: else
337: l_stmt:='select dim_name,dim_id from edw_dimensions_md_v where dim_name=:s';
338: end if;
339: if g_debug then

Line 337: l_stmt:='select dim_name,dim_id from edw_dimensions_md_v where dim_name=:s';

333: g_dim_id(g_number_dims):=null;
334: if p_type='LONGNAME' then
335: l_stmt:='select dim_name,dim_id from edw_dimensions_md_v where dim_long_name=:s';
336: else
337: l_stmt:='select dim_name,dim_id from edw_dimensions_md_v where dim_name=:s';
338: end if;
339: if g_debug then
340: write_to_log_file_n('Going to execute ');
341: write_to_log_file(l_stmt);

Line 1287: l_stmt:='select pk_item.column_name from edw_dimensions_md_v rel , edw_unique_keys_md_v pk, '||

1283: l_stmt varchar2(4000);
1284: TYPE CurTyp IS REF CURSOR;
1285: cv CurTyp;
1286: Begin
1287: l_stmt:='select pk_item.column_name from edw_dimensions_md_v rel , edw_unique_keys_md_v pk, '||
1288: 'edw_pvt_key_columns_md_v isu,edw_pvt_columns_md_v pk_item where rel.dim_name=:a '||
1289: 'and pk.entity_id=rel.dim_id and pk.primarykey=1 '||
1290: 'and isu.key_id=pk.key_id and pk_item.column_id=isu.column_id ';
1291: if g_debug then