APPS.OE_MARGIN_PVT dependencies on OE_ORDER_LINES_ALL

Line 943: FROM OE_ORDER_LINES_ALL

939: l_ordered_qty Number;
940:
941: CURSOR MARGIN is
942: SELECT ordered_quantity, unit_selling_price, unit_cost
943: FROM OE_ORDER_LINES_ALL
944: WHERE header_id = p_header_id
945: AND unit_cost IS NOT NULL
946: AND line_category_code = 'ORDER';
947: --bug 5654745}

Line 989: FROM OE_ORDER_LINES_ALL

985: /* SELECT SUM(ordered_quantity*(unit_selling_price - unit_cost))/sum(ordered_quantity*unit_selling_price),
986: SUM(ordered_quantity*(unit_selling_price - unit_cost))
987: INTO l_margin_ratio,
988: l_margin_amount
989: FROM OE_ORDER_LINES_ALL
990: WHERE header_id = p_header_id
991: AND unit_cost IS NOT NULL
992: -- AND unit_selling_price > 0
993: AND line_category_code = 'ORDER'; */

Line 1018: FROM OE_ORDER_LINES_ALL

1014: /* SELECT SUM(ordered_quantity*(unit_selling_price - unit_cost))/sum(ordered_quantity*unit_cost),
1015: SUM(ordered_quantity*(unit_selling_price- unit_cost))
1016: INTO l_margin_ratio,
1017: l_margin_amount
1018: FROM OE_ORDER_LINES_ALL
1019: WHERE header_id = p_header_id
1020: AND unit_cost IS NOT NULL
1021: AND line_category_code = 'ORDER'; */
1022: l_margin_ratio := l_margin_amount/l_total_cost; --bug 5654745