DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 208: FROM oe_order_lines_all ol, mtl_system_items_tl msi

204: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'LINES') lines_total,
205: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'TAXES') taxes_total,
206: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'CHARGES') charges_total,
207: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'ALL') extended_price
208: FROM oe_order_lines_all ol, mtl_system_items_tl msi
209: WHERE ol.header_id = p_order_id
210: and ol.inventory_item_id = msi.inventory_item_id
211: and msi.organization_id = oe_profile.value('OE_ORGANIZATION_ID', ol.org_id)
212: and msi.language = userenv('LANG')