DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 198: FROM oe_order_lines_all ol, mtl_system_items_tl msi

194: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'LINES') lines_total,
195: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'TAXES') taxes_total,
196: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'CHARGES') charges_total,
197: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'ALL') extended_price
198: FROM oe_order_lines_all ol, mtl_system_items_tl msi
199: WHERE ol.header_id = p_order_id
200: and ol.inventory_item_id = msi.inventory_item_id
201: and msi.organization_id = oe_profile.value('OE_ORGANIZATION_ID', ol.org_id)
202: and msi.language = userenv('LANG')