DBA Data[Home] [Help]

APPS.QPR_SR_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 456: FROM mtl_system_items

452:
453: if p_instance_id is null then
454: SELECT nvl(primary_uom_code, 'Ea')
455: INTO s_master_uom
456: FROM mtl_system_items
457: WHERE inventory_item_id = p_item_id
458: AND organization_id = l_master_org;
459: else
460: s_tbl_name := 'mtl_system_items' || get_dblink(p_instance_id);

Line 460: s_tbl_name := 'mtl_system_items' || get_dblink(p_instance_id);

456: FROM mtl_system_items
457: WHERE inventory_item_id = p_item_id
458: AND organization_id = l_master_org;
459: else
460: s_tbl_name := 'mtl_system_items' || get_dblink(p_instance_id);
461: l_sql := 'SELECT nvl(primary_uom_code, ''Ea'') from ' || s_tbl_name;
462: l_sql := l_sql || ' WHERE inventory_item_id = ' || p_item_id;
463: l_sql := l_sql || ' AND organization_id = ' || l_master_org;
464: execute immediate l_sql into s_master_uom;