APPS.OE_MARGIN_PVT dependencies on OE_ORDER_LINES_ALL

Line 827: FROM OE_ORDER_LINES_ALL

823: l_ordered_qty Number;
824:
825: CURSOR MARGIN is
826: SELECT ordered_quantity, unit_selling_price, unit_cost
827: FROM OE_ORDER_LINES_ALL
828: WHERE header_id = p_header_id
829: AND unit_cost IS NOT NULL
830: AND line_category_code = 'ORDER';
831: --bug 5654745}

Line 873: FROM OE_ORDER_LINES_ALL

869: /* SELECT SUM(ordered_quantity*(unit_selling_price - unit_cost))/sum(ordered_quantity*unit_selling_price),
870: SUM(ordered_quantity*(unit_selling_price - unit_cost))
871: INTO l_margin_ratio,
872: l_margin_amount
873: FROM OE_ORDER_LINES_ALL
874: WHERE header_id = p_header_id
875: AND unit_cost IS NOT NULL
876: -- AND unit_selling_price > 0
877: AND line_category_code = 'ORDER'; */

Line 902: FROM OE_ORDER_LINES_ALL

898: /* SELECT SUM(ordered_quantity*(unit_selling_price - unit_cost))/sum(ordered_quantity*unit_cost),
899: SUM(ordered_quantity*(unit_selling_price- unit_cost))
900: INTO l_margin_ratio,
901: l_margin_amount
902: FROM OE_ORDER_LINES_ALL
903: WHERE header_id = p_header_id
904: AND unit_cost IS NOT NULL
905: AND line_category_code = 'ORDER'; */
906: l_margin_ratio := l_margin_amount/l_total_cost; --bug 5654745