DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_GRP dependencies on MTL_SYSTEM_ITEMS

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

Line 6289: FROM mtl_system_items

6285: SELECT eam_item_type,
6286: serial_number_control_code
6287: INTO l_eam_item_type,
6288: l_serial_control_code
6289: FROM mtl_system_items
6290: WHERE inventory_item_id = p_instance_tbl(inst_tab_row).inventory_item_id
6291: AND organization_id = p_instance_tbl(inst_tab_row).vld_organization_id;
6292:
6293: IF l_eam_item_type in (1, 3) AND l_serial_control_code <> 1 THEN