DBA Data[Home] [Help]

APPS.ISC_EDW_BACKLOGS_F_SIZE dependencies on OE_ORDER_HEADERS_ALL

Line 46: oe_order_headers_all h,

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,
50: mtl_system_items_b p_mtl,

Line 147: FROM OE_ORDER_HEADERS_ALL

143: nvl(avg(nvl(vsize(sales_channel_code),0)),0),
144: nvl(avg(nvl(vsize(transactional_curr_code),0)),0),
145: nvl(avg(nvl(vsize(salesrep_id),0)),0),
146: nvl(avg(nvl(vsize(order_category_code),0)),0)
147: FROM OE_ORDER_HEADERS_ALL
148: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
149:
150: CURSOR c_4 IS
151: SELECT nvl(avg(nvl(vsize(party_site_id),0)),0)