APPS.ISC_FS_TASK_ETL_PKG dependencies on MTL_UOM_CONVERSIONS

Line 45: from mtl_uom_conversions

41: cursor c_time_base is
42: select 1 / decode( conversion_rate
43: , 0 , 1 -- prevent "divide by zero" error
44: , conversion_rate )
45: from mtl_uom_conversions
46: where uom_class = g_time_uom_class
47: and uom_code = g_uom_hours
48: and inventory_item_id = 0;
49:

Line 1320: , mtl_uom_conversions t_eff

1316: and nvl(t.object_capacity_id,-123) = oc.object_capacity_id(+)
1317: -- R12 dep/arr
1318: and t.task_type_id = bf.task_type_id(+)
1319: ) x
1320: , mtl_uom_conversions t_eff
1321: , mtl_uom_conversions t_peff
1322: , mtl_uom_conversions ta_eff
1323: , mtl_uom_conversions ta_std
1324: , mtl_uom_conversions ta_atd

Line 1321: , mtl_uom_conversions t_peff

1317: -- R12 dep/arr
1318: and t.task_type_id = bf.task_type_id(+)
1319: ) x
1320: , mtl_uom_conversions t_eff
1321: , mtl_uom_conversions t_peff
1322: , mtl_uom_conversions ta_eff
1323: , mtl_uom_conversions ta_std
1324: , mtl_uom_conversions ta_atd
1325: where

Line 1322: , mtl_uom_conversions ta_eff

1318: and t.task_type_id = bf.task_type_id(+)
1319: ) x
1320: , mtl_uom_conversions t_eff
1321: , mtl_uom_conversions t_peff
1322: , mtl_uom_conversions ta_eff
1323: , mtl_uom_conversions ta_std
1324: , mtl_uom_conversions ta_atd
1325: where
1326: --

Line 1323: , mtl_uom_conversions ta_std

1319: ) x
1320: , mtl_uom_conversions t_eff
1321: , mtl_uom_conversions t_peff
1322: , mtl_uom_conversions ta_eff
1323: , mtl_uom_conversions ta_std
1324: , mtl_uom_conversions ta_atd
1325: where
1326: --
1327: t_peff.inventory_item_id = 0

Line 1324: , mtl_uom_conversions ta_atd

1320: , mtl_uom_conversions t_eff
1321: , mtl_uom_conversions t_peff
1322: , mtl_uom_conversions ta_eff
1323: , mtl_uom_conversions ta_std
1324: , mtl_uom_conversions ta_atd
1325: where
1326: --
1327: t_peff.inventory_item_id = 0
1328: and t_peff.uom_class = g_time_uom_class

Line 1592: , mtl_uom_conversions t_sch

1588: and source_object_type_code = 'SR'
1589: ) e
1590: , jtf_rs_default_groups dga
1591: , jtf_task_statuses_b ts
1592: , mtl_uom_conversions t_sch
1593: , mtl_uom_conversions t_act
1594: , mtl_uom_conversions e_act
1595: where
1596: -- needs to be out to handle deleted assignments

Line 1593: , mtl_uom_conversions t_act

1589: ) e
1590: , jtf_rs_default_groups dga
1591: , jtf_task_statuses_b ts
1592: , mtl_uom_conversions t_sch
1593: , mtl_uom_conversions t_act
1594: , mtl_uom_conversions e_act
1595: where
1596: -- needs to be out to handle deleted assignments
1597: e.task_assignment_id = ta.task_assignment_id(+)

Line 1594: , mtl_uom_conversions e_act

1590: , jtf_rs_default_groups dga
1591: , jtf_task_statuses_b ts
1592: , mtl_uom_conversions t_sch
1593: , mtl_uom_conversions t_act
1594: , mtl_uom_conversions e_act
1595: where
1596: -- needs to be out to handle deleted assignments
1597: e.task_assignment_id = ta.task_assignment_id(+)
1598: -- needs nvl/outer to handle deleted assignments

Line 2236: , mtl_uom_conversions t_eff

2232: jtf_tasks_b t
2233: , isc_fs_task_assignmnts_f ta
2234: , jtf_task_statuses_b ts
2235: , jtf_task_types_b tt
2236: , mtl_uom_conversions t_eff
2237: , mtl_uom_conversions t_peff
2238: , ( select /*+ NO_MERGE */ distinct
2239: source_object_id
2240: from

Line 2237: , mtl_uom_conversions t_peff

2233: , isc_fs_task_assignmnts_f ta
2234: , jtf_task_statuses_b ts
2235: , jtf_task_types_b tt
2236: , mtl_uom_conversions t_eff
2237: , mtl_uom_conversions t_peff
2238: , ( select /*+ NO_MERGE */ distinct
2239: source_object_id
2240: from
2241: isc_fs_events_stg