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.OPI_EDW_COGS_F_SZ dependencies on OE_ORDER_HEADERS_ALL

Line 12: oe_order_headers_all h,

8: CURSOR c_cnt_rows IS
9: select sum(cnt)
10: from (SELECT count(*) cnt
11: FROM
12: oe_order_headers_all h,
13: oe_order_lines_all pl,
14: oe_order_lines_all l,
15: wsh_delivery_details wdd,
16: mtl_transaction_accounts mta,

Line 40: oe_order_headers_all h,

36: BETWEEN p_from_date and p_to_date
37: UNION ALL
38: SELECT count(*) cnt
39: from
40: oe_order_headers_all h,
41: oe_order_lines_all pl,
42: oe_order_lines_all cl,
43: oe_order_lines_all l,
44: mtl_transaction_accounts mta,

Line 66: oe_order_headers_all h,

62: BETWEEN p_from_date and p_to_date
63: UNION ALL
64: SELECT count(*) cnt
65: FROM
66: oe_order_headers_all h,
67: oe_order_lines_all pl, /* parent line */
68: oe_order_lines_all l, /* child line */
69: ra_customer_trx_lines_all rcl,
70: ap_invoice_distributions_all aid,

Line 149: FROM oe_order_headers_all

145: avg(nvl(vsize(salesrep_id), 0)) salesrep_id,
146: avg(nvl(vsize(order_category_code), 0)) order_category_code,
147: avg(nvl(vsize(header_id), 0)) header_id,
148: avg(nvl(vsize(order_number), 0)) order_number
149: FROM oe_order_headers_all
150: WHERE last_update_date between p_from_date and p_to_date;
151:
152: CURSOR c_lookup IS
153: select avg(nvl(vsize(lookup_code_pk), 0))