APPS.CSI_ITEM_INSTANCE_GRP dependencies on MTL_SYSTEM_ITEMS

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 6457: FROM mtl_system_items

6453: SELECT eam_item_type,
6454: serial_number_control_code
6455: INTO l_eam_item_type,
6456: l_serial_control_code
6457: FROM mtl_system_items
6458: WHERE inventory_item_id = p_instance_tbl(inst_tab_row).inventory_item_id
6459: AND organization_id = p_instance_tbl(inst_tab_row).vld_organization_id;
6460:
6461: IF l_eam_item_type in (1, 3) AND l_serial_control_code <> 1 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