APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on MTL_SYSTEM_ITEMS

Line 1569: FROM mtl_system_items i,

1565:
1566: /* INVCONV cursor to get secondary unit of measure for the item*/
1567: CURSOR cr_get_sec_uom IS
1568: SELECT m.unit_of_measure
1569: FROM mtl_system_items i,
1570: mtl_units_of_measure m
1571: WHERE i.inventory_item_id = l_item_id
1572: AND i.organization_id = l_organization_id
1573: AND i.secondary_uom_code = m.uom_code;