APPS.ISC_EDW_BACKLOGS_F_SIZE dependencies on OE_ORDER_LINES_ALL

Line 45: oe_order_lines_all pl,

41: ||'-'|| nvl( os_2.order_source_id, os_1.order_source_id)
42: ||'-'|| fspa.set_of_books_id BACKLOGS_PK
43: FROM edw_local_instance inst,
44: oe_transaction_types_tl ot,
45: oe_order_lines_all pl,
46: oe_order_headers_all h,
47: oe_order_lines_all l,
48: oe_order_sources os_1,
49: oe_order_sources os_2,

Line 47: oe_order_lines_all l,

43: FROM edw_local_instance inst,
44: oe_transaction_types_tl ot,
45: oe_order_lines_all pl,
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,

Line 134: FROM OE_ORDER_LINES_ALL

130: nvl(avg(nvl(vsize(line_category_code),0)),0),
131: nvl(avg(nvl(vsize(salesrep_id),0)),0),
132: nvl(avg(nvl(vsize(ship_to_org_id),0)),0),
133: nvl(avg(nvl(vsize(task_id),0)),0)
134: FROM OE_ORDER_LINES_ALL
135: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
136:
137: CURSOR c_2 IS
138: SELECT nvl(avg(nvl(vsize(UOM_EDW_BASE_UOM),0)),0)

Line 180: FROM oe_order_lines_all l,

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))
179: *nvl(EDW_CONVERSION_RATE,0)),0)),0)
180: FROM oe_order_lines_all l,
181: OPI_EDW_LOCAL_UOM_CONV_F;
182:
183: BEGIN
184: