APPS.OE_OE_HTML_LINE_EXT dependencies on OE_ORDER_LINES

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 315: FROM OE_ORDER_LINES

311: G_LINE_NUMBER:=x_line_number;
312: IF x_line_number IS NOT NULL THEN
313: SELECT NVL(MAX(SHIPMENT_NUMBER)+1,1)
314: INTO x_shipment_number
315: FROM OE_ORDER_LINES
316: WHERE HEADER_ID = p_header_id
317: AND LINE_NUMBER = l_line_number;
318: G_SHIPMENT_NUMBER:=x_shipment_number;
319: END IF;

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