APPS.BIM_EDW_OFFERS_M_SIZE dependencies on QP_LIST_HEADERS_VL

Line 16: qp_list_headers_vl qlh ,

12: select sum(cnt)
13: from (
14: select count(*) cnt
15: from ams_act_offers aao ,
16: qp_list_headers_vl qlh ,
17: edw_local_instance inst
18: WHERE aao.qp_list_header_id = qlh.list_header_id and
19: ((aao.last_update_date > to_date('1000/01/01', 'YYYY/MM/DD'))
20: or (qlh.last_update_date > to_date('1000/01/01', 'YYYY/MM/DD')))

Line 80: FROM qp_list_headers_vl;

76: select
77: avg(nvl(vsize(name ), 0)),
78: avg(nvl(vsize(list_header_id ), 0)),
79: avg(nvl(vsize(description ), 0))
80: FROM qp_list_headers_vl;
81:
82: BEGIN
83:
84: dbms_output.enable(1000000);