APPS.ISC_EDW_BACKLOGS_F_SIZE dependencies on GL_SETS_OF_BOOKS

Line 53: gl_sets_of_books gl

49: oe_order_sources os_2,
50: mtl_system_items_b p_mtl,
51: mtl_system_items_b mtl,
52: financials_system_params_all fspa,
53: gl_sets_of_books gl
54: WHERE (h.last_update_date between p_from_date and p_to_date
55: OR l.last_update_date between p_from_date and p_to_date)
56: AND h.open_flag = 'Y'
57: AND h.booked_flag = 'Y'

Line 156: FROM GL_SETS_OF_BOOKS;

152: FROM HZ_CUST_ACCT_SITES_ALL;
153:
154: CURSOR c_5 IS
155: SELECT nvl(avg(nvl(vsize(period_set_name),0)),0) + nvl(avg(nvl(vsize(accounted_period_type),0)),0)
156: FROM GL_SETS_OF_BOOKS;
157:
158: CURSOR c_6 IS
159: SELECT nvl(avg(nvl(vsize(name),0)),0)
160: FROM OE_ORDER_SOURCES;