eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_EDW_BACKLOGS_F_SIZE dependencies on MTL_SYSTEM_ITEMS_B

Line 50: mtl_system_items_b p_mtl,

46: oe_order_headers_all h,
47: oe_order_lines_all l,
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

Line 51: mtl_system_items_b mtl,

47: oe_order_lines_all l,
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)

Line 174: FROM mtl_system_items_b;

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)
174: FROM mtl_system_items_b;
175:
176: CURSOR c_10 IS
177: SELECT nvl(avg(nvl(vsize(nvl(l.unit_selling_price,0)
178: *(nvl(l.ordered_quantity,0)-nvl(l.invoiced_quantity,0))