APPS.CSI_ITEM_INSTANCE_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 140: from MTL_SYSTEM_ITEMS_B

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

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

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

Line 7756: from MTL_SYSTEM_ITEMS_B

7752: l_base_item_id := null;
7753: Begin
7754: select base_item_id
7755: into l_base_item_id
7756: from MTL_SYSTEM_ITEMS_B
7757: where inventory_item_id = p_instance_tbl(inst_row).inventory_item_id
7758: and organization_id = p_instance_tbl(inst_row).vld_organization_id;
7759: Exception
7760: when no_data_found then