DBA Data[Home] [Help]

APPS.OE_OE_HTML_LINE_EXT dependencies on MTL_SYSTEM_ITEMS_TL

Line 363: mtl_system_items_tl itemstl,

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
367: Where line.inventory_item_id =items.inventory_item_id(+)