DBA Data[Home] [Help]

APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on MTL_SYSTEM_ITEMS

Line 1369: FROM mtl_system_items i,

1365:
1366: /* INVCONV cursor to get secondary unit of measure for the item*/
1367: CURSOR cr_get_sec_uom IS
1368: SELECT m.unit_of_measure
1369: FROM mtl_system_items i,
1370: mtl_units_of_measure m
1371: WHERE i.inventory_item_id = l_item_id
1372: AND i.organization_id = l_organization_id
1373: AND i.secondary_uom_code = m.uom_code;