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.

[Home] [Help]

APPS.OPI_EDW_COGS_F_SZ dependencies on OE_ORDER_LINES_ALL

Line 13: oe_order_lines_all pl,

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,
17: mtl_material_transactions mmt

Line 14: oe_order_lines_all l,

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,
17: mtl_material_transactions mmt
18: where mmt.transaction_source_type_id = 2

Line 41: oe_order_lines_all pl,

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,
45: mtl_material_transactions mmt

Line 42: oe_order_lines_all cl,

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,
45: mtl_material_transactions mmt
46: where mmt.transaction_source_type_id = 12

Line 43: oe_order_lines_all l,

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,
45: mtl_material_transactions mmt
46: where mmt.transaction_source_type_id = 12
47: and mta.transaction_source_type_id = 12

Line 67: oe_order_lines_all pl, /* parent line */

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,
71: ap_invoices_all ai,

Line 68: oe_order_lines_all l, /* child line */

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,
71: ap_invoices_all ai,
72: mtl_material_transactions mmt,

Line 140: FROM oe_order_lines_all

136: avg(nvl(vsize(project_id), 0)) project_id,
137: avg(nvl(vsize(task_id), 0)) task_id,
138: avg(nvl(vsize(source_type_code), 0)) source_type_code,
139: avg(nvl(vsize(marketing_source_code_id), 0)) marketing_source_code_id
140: FROM oe_order_lines_all
141: WHERE last_update_date between p_from_date and p_to_date;
142:
143: CURSOR c_header IS
144: SELECT avg(nvl(vsize(sales_channel_code), 0)) channel_code,