APPS.BIC_SUMMARY_EXTRACT_PKG dependencies on ASO_I_OE_ORDER_LINES_V

Line 2342: FROM aso_i_oe_order_lines_v ool,

2338: null)) order_qty,
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

Line 2415: aso_i_oe_order_lines_v ool,

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
2419: trunc(bdt.start_date)