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;
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;
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;
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
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;
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;