APPS.ISC_MAINT_LAB_BLG_ETL_PKG dependencies on MTL_UOM_CONVERSIONS

Line 26: from mtl_uom_conversions

22: cursor c_time_base is
23: select 1 / decode( conversion_rate
24: , 0 , 1 -- prevent "divide by zero" error
25: , conversion_rate )
26: from mtl_uom_conversions
27: where uom_class = g_bom_time_class
28: and uom_code = g_bom_hour_code
29: and inventory_item_id = 0;
30: begin

Line 250: ,mtl_uom_conversions m1

246: WIP_OPERATIONS wo
247: ,WIP_OPERATION_RESOURCES wor
248: ,BOM_RESOURCES br
249: ,ISC_MAINT_WORK_ORDERS_F fact -- get only the work orders that satisfy the G_start_date criteria
250: ,mtl_uom_conversions m1
251:
252: where
253: fact.status_type in (17,6,3,1) and --to get the work orders in the status draft,released,unreleased and on-hold
254: fact.organization_id = wo.organization_id and -- to get the same organizational work orders.