DBA Data[Home] [Help]

APPS.WIP_WS_LABOR_METRIC_PUB dependencies on MTL_UOM_CONVERSIONS

Line 26: from mtl_uom_conversions muc1,

22: l_time_based_uom_flag number;
23:
24: cursor time_based_uom_cursor is
25: select distinct muc1.uom_class
26: from mtl_uom_conversions muc1,
27: mtl_uom_conversions muc2
28: where (muc1.uom_class = muc2.uom_class
29: and nvl(muc1.disable_date, sysdate + 1) > sysdate)
30: and nvl(muc2.disable_date, sysdate + 1) > sysdate

Line 27: mtl_uom_conversions muc2

23:
24: cursor time_based_uom_cursor is
25: select distinct muc1.uom_class
26: from mtl_uom_conversions muc1,
27: mtl_uom_conversions muc2
28: where (muc1.uom_class = muc2.uom_class
29: and nvl(muc1.disable_date, sysdate + 1) > sysdate)
30: and nvl(muc2.disable_date, sysdate + 1) > sysdate
31: and muc1.uom_code = fnd_profile.value('BOM:HOUR_UOM_CODE')