DBA Data[Home] [Help]

APPS.INV_GMI_MIGRATION dependencies on MTL_SYSTEM_ITEMS_B

Line 131: FROM mtl_system_items_b

127:
128: BEGIN
129: SELECT segment1 ||'('||to_char(p_ditem_id)||')'
130: INTO l_return_val
131: FROM mtl_system_items_b
132: WHERE organization_id = p_organization_id AND
133: inventory_item_id = p_ditem_id;
134: EXCEPTION
135: WHEN NO_DATA_FOUND THEN

Line 1651: FROM mtl_system_items_b i,

1647: bu.uom_class
1648: INTO l_from_unit_of_measure,
1649: l_from_uom_code,
1650: l_from_uom_class
1651: FROM mtl_system_items_b i,
1652: mtl_units_of_measure iu,
1653: mtl_units_of_measure bu
1654: WHERE
1655: i.organization_id = c.organization_id