DBA Data[Home] [Help]

APPS.WIP_WS_TIME_ENTRY dependencies on MTL_UOM_CONVERSIONS

Line 1581: from mtl_uom_conversions muc,

1577: l_time_based_uom_flag varchar2(1);
1578:
1579: cursor time_based_uom_cursor is
1580: select distinct muc.uom_class
1581: from mtl_uom_conversions muc,
1582: mtl_uom_conversions muc2
1583: where (muc.uom_class = muc2.uom_class and
1584: nvl(muc.disable_date, sysdate + 1) > sysdate) and
1585: nvl(muc2.disable_date, sysdate + 1) > sysdate and

Line 1582: mtl_uom_conversions muc2

1578:
1579: cursor time_based_uom_cursor is
1580: select distinct muc.uom_class
1581: from mtl_uom_conversions muc,
1582: mtl_uom_conversions muc2
1583: where (muc.uom_class = muc2.uom_class and
1584: nvl(muc.disable_date, sysdate + 1) > sysdate) and
1585: nvl(muc2.disable_date, sysdate + 1) > sysdate and
1586: muc.uom_code = fnd_profile.value('BOM:HOUR_UOM_CODE') and