DBA Data[Home] [Help]

APPS.INV_GMI_MIGRATION dependencies on MTL_SYSTEM_ITEMS_B

Line 170: FROM mtl_system_items_b

166:
167: BEGIN
168: SELECT segment1 ||'('||to_char(p_ditem_id)||')'
169: INTO l_return_val
170: FROM mtl_system_items_b
171: WHERE organization_id = p_organization_id AND
172: inventory_item_id = p_ditem_id;
173: EXCEPTION
174: WHEN NO_DATA_FOUND THEN

Line 1743: FROM mtl_system_items_b i,

1739: bu.uom_class
1740: INTO l_from_unit_of_measure,
1741: l_from_uom_code,
1742: l_from_uom_class
1743: FROM mtl_system_items_b i,
1744: mtl_units_of_measure iu,
1745: mtl_units_of_measure bu
1746: WHERE
1747: i.organization_id = c.organization_id