DBA Data[Home] [Help]

APPS.MTL_MOVEMENT_STAT_PKG dependencies on MTL_UOM_CONVERSIONS_VIEW

Line 99: from mtl_uom_conversions_view c1,

95: -- Find conversion factor.
96: --
97: select c1.conversion_rate / c2.conversion_rate
98: into l_conversion_factor
99: from mtl_uom_conversions_view c1,
100: mtl_uom_conversions_view c2
101: where c1.organization_id = P_ORGANIZATION_ID
102: and c2.organization_id = P_ORGANIZATION_ID
103: and c1.inventory_item_id = P_INVENTORY_ITEM_ID

Line 100: mtl_uom_conversions_view c2

96: --
97: select c1.conversion_rate / c2.conversion_rate
98: into l_conversion_factor
99: from mtl_uom_conversions_view c1,
100: mtl_uom_conversions_view c2
101: where c1.organization_id = P_ORGANIZATION_ID
102: and c2.organization_id = P_ORGANIZATION_ID
103: and c1.inventory_item_id = P_INVENTORY_ITEM_ID
104: and c2.inventory_item_id = P_INVENTORY_ITEM_ID