DBA Data[Home] [Help]

APPS.BIM_EDW_IH_REASN_M_SIZE dependencies on JTF_IH_REASONS_VL

Line 15: FROM JTF_IH_REASONS_VL RSN ,

11: CURSOR c_cnt_rows IS
12: select sum(cnt)
13: from (
14: select count(*) cnt
15: FROM JTF_IH_REASONS_VL RSN ,
16: EDW_LOCAL_INSTANCE INST
17: where RSN.last_update_date between
18: p_from_date and p_to_date
19: );

Line 55: FROM JTF_IH_REASONS_VL

51: avg(nvl(vsize(REASON_ID ), 0)),
52: avg(nvl(vsize(SHORT_DESCRIPTION ), 0)),
53: avg(nvl(vsize(REASON_CODE ), 0)),
54: avg(nvl(vsize(LONG_DESCRIPTION ), 0))
55: FROM JTF_IH_REASONS_VL
56: WHERE
57: last_update_date between
58: p_from_date and p_to_date;
59: