APPS.OE_OE_HTML_LINE_EXT dependencies on OE_ORDER_LINES_ALL

Line 308: FROM OE_ORDER_LINES_ALL

304:
305: IF G_LINE_NUMBER IS NULL THEN
306: SELECT NVL(MAX(LINE_NUMBER)+1,1)
307: INTO x_line_number
308: FROM OE_ORDER_LINES_ALL
309: WHERE HEADER_ID = p_header_id;
310: l_line_number:=x_line_number;
311: G_LINE_NUMBER:=x_line_number;
312: IF x_line_number IS NOT NULL THEN

Line 362: from oe_order_lines_all line,

358: decode(line.option_number,null,null,'.'||line.option_number) line_num,
359: line.unit_selling_price*decode(line.line_category_code,'RETURN',-1,1) unit_selling_price,
360: (nvl(line.ordered_quantity,line.ordered_quantity)*line.unit_selling_price)*decode(line.line_category_code,'RETURN',-1,1) extended_price,
361: DECODE(line.ITEM_IDENTIFIER_TYPE, 'CUST', NVL(C.CUSTOMER_ITEM_DESC,ITEMSTL.DESCRIPTION), 'INT', ITEMSTL.DESCRIPTION, null, ITEMSTL.DESCRIPTION, NVL(REF.DESCRIPTION,ITEMSTL.DESCRIPTION)) ITEM_DESCRIPTION
362: from oe_order_lines_all line,
363: mtl_system_items_tl itemstl,
364: mtl_customer_items c,
365: mtl_cross_references ref,
366: mtl_system_items_b_kfv items