DBA Data[Home] [Help]

APPS.ISC_EDW_BACKLOGS_F_SIZE dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 52: financials_system_params_all fspa,

48: oe_order_sources os_1,
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'

Line 169: FROM FINANCIALS_SYSTEM_PARAMS_ALL;

165:
166: CURSOR c_8 IS
167: SELECT nvl(avg(nvl(vsize(to_char(set_of_books_id)),0)),0),
168: nvl(avg(nvl(vsize(set_of_books_id),0)),0)
169: FROM FINANCIALS_SYSTEM_PARAMS_ALL;
170:
171: CURSOR c_9 IS
172: SELECT nvl(avg(nvl(vsize(inventory_item_id),0)),0),
173: nvl(avg(nvl(vsize(organization_id),0)),0)