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 OE_ORDER_LINES_ALL

Line 2355: x_order_qty oe_order_lines_all.ordered_quantity % type;

2351: and hca.cust_account_id = ooh.sold_to_org_id
2352: group by hca.party_id , bdt.start_date, ooh.org_id
2353: ;
2354: x_orders number;
2355: x_order_qty oe_order_lines_all.ordered_quantity % type;
2356: x_order_amt oe_order_lines_all.unit_selling_price % type;
2357: x_returns number;
2358: x_return_qty oe_order_lines_all.ordered_quantity % type;
2359: x_return_amt oe_order_lines_all.unit_selling_price % type;

Line 2356: x_order_amt oe_order_lines_all.unit_selling_price % type;

2352: group by hca.party_id , bdt.start_date, ooh.org_id
2353: ;
2354: x_orders number;
2355: x_order_qty oe_order_lines_all.ordered_quantity % type;
2356: x_order_amt oe_order_lines_all.unit_selling_price % type;
2357: x_returns number;
2358: x_return_qty oe_order_lines_all.ordered_quantity % type;
2359: x_return_amt oe_order_lines_all.unit_selling_price % type;
2360: x_party_id hz_parties.party_id % type;

Line 2358: x_return_qty oe_order_lines_all.ordered_quantity % type;

2354: x_orders number;
2355: x_order_qty oe_order_lines_all.ordered_quantity % type;
2356: x_order_amt oe_order_lines_all.unit_selling_price % type;
2357: x_returns number;
2358: x_return_qty oe_order_lines_all.ordered_quantity % type;
2359: x_return_amt oe_order_lines_all.unit_selling_price % type;
2360: x_party_id hz_parties.party_id % type;
2361: x_org_id oe_order_headers_all.org_id % type;
2362: x_start_date date;

Line 2359: x_return_amt oe_order_lines_all.unit_selling_price % type;

2355: x_order_qty oe_order_lines_all.ordered_quantity % type;
2356: x_order_amt oe_order_lines_all.unit_selling_price % type;
2357: x_returns number;
2358: x_return_qty oe_order_lines_all.ordered_quantity % type;
2359: x_return_amt oe_order_lines_all.unit_selling_price % type;
2360: x_party_id hz_parties.party_id % type;
2361: x_org_id oe_order_headers_all.org_id % type;
2362: x_start_date date;
2363: begin

Line 2433: x_ontime_val oe_order_lines_all.unit_selling_price % type;

2429: ooh.org_id;
2430:
2431: x_line_ontime number;
2432: x_line_del number;
2433: x_ontime_val oe_order_lines_all.unit_selling_price % type;
2434: x_del_val oe_order_lines_all.unit_selling_price % type;
2435:
2436: x_party_id hz_parties.party_id % type;
2437: x_org_id oe_order_headers_all.org_id % type;

Line 2434: x_del_val oe_order_lines_all.unit_selling_price % type;

2430:
2431: x_line_ontime number;
2432: x_line_del number;
2433: x_ontime_val oe_order_lines_all.unit_selling_price % type;
2434: x_del_val oe_order_lines_all.unit_selling_price % type;
2435:
2436: x_party_id hz_parties.party_id % type;
2437: x_org_id oe_order_headers_all.org_id % type;
2438: x_start_date date;