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.BIC_SUMMARY_EXTRACT_PKG dependencies on ASO_I_OE_ORDER_HEADERS_V

Line 2117: from oe_order_headers_all aoh, --4434468 replaced aso_i_oe_order_headers_v with oe_order_headers_all

2113: g_program_application_id,
2114: g_program_id,
2115: g_last_update_login,
2116: 'ACTIVATION'
2117: from oe_order_headers_all aoh, --4434468 replaced aso_i_oe_order_headers_v with oe_order_headers_all
2118: bic_party_summary bcs,
2119: hz_cust_accounts acct
2120: where bcs.measure_id = g_measure_id_for_acqu
2121:

Line 2343: aso_i_oe_order_headers_v ooh,

2339: sum(decode(ool.line_category_code,'RETURN',
2340: ool.ordered_quantity - nvl(ool.cancelled_quantity,0),
2341: null)) return_qty
2342: FROM aso_i_oe_order_lines_v ool,
2343: aso_i_oe_order_headers_v ooh,
2344: bic_dimv_time bdt,
2345: hz_cust_accounts hca
2346: WHERE ooh.header_id = ool.header_id
2347: AND ooh.sold_to_org_id is not null

Line 2414: aso_i_oe_order_headers_v ooh,

2410: ooh.ordered_date,
2411: ool.unit_selling_price)
2412: )) ontime_val
2413: from
2414: aso_i_oe_order_headers_v ooh,
2415: aso_i_oe_order_lines_v ool,
2416: hz_cust_accounts hca,
2417: bic_dimv_time bdt
2418: where