DBA Data[Home] [Help]

APPS.BIM_EDW_IH_RESLT_M_SIZE dependencies on JTF_IH_RESULTS_VL

Line 15: FROM JTF_IH_RESULTS_VL RSLT ,

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

Line 57: FROM JTF_IH_RESULTS_VL

53: avg(nvl(vsize(SHORT_DESCRIPTION ), 0)),
54: avg(nvl(vsize(RESULT_CODE ), 0)),
55: avg(nvl(vsize(POSITIVE_RESPONSE_FLAG ), 0)),
56: avg(nvl(vsize(LONG_DESCRIPTION ), 0))
57: FROM JTF_IH_RESULTS_VL
58: where
59: last_update_date between
60: p_from_date and p_to_date;
61: