DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 139: from MTL_SYSTEM_ITEMS_B

135: l_base_item_id := NULL;
136: Begin
137: select base_item_id
138: into l_base_item_id
139: from MTL_SYSTEM_ITEMS_B
140: where inventory_item_id = p_instance_rec.inventory_item_id
141: and organization_id = p_instance_rec.vld_organization_id;
142: Exception
143: when no_data_found then

Line 167: where exists (select 'x' from mtl_system_items_b msi

163: Begin
164: select 1
165: into l_count
166: from dual
167: where exists (select 'x' from mtl_system_items_b msi
168: where msi.base_item_id = l_base_item_id
169: and msi.inventory_item_id = p_instance_tbl(j).inventory_item_id);
170: Exception
171: when no_data_found then