APPS.CSI_FA_INSTANCE_GRP dependencies on MTL_SYSTEM_ITEMS

Line 153: FROM mtl_system_items

149: serial_number_control_code
150: INTO l_asset_creation_code,
151: l_inventory_item,
152: l_serial_code
153: FROM mtl_system_items
154: WHERE inventory_item_id = l_inventory_item_id
155: AND organization_id = l_organization_id;
156:
157: IF nvl(l_asset_creation_code,'0') in ('1', 'Y') THEN

Line 474: FROM mtl_system_items

470: SELECT eam_item_type,
471: serial_number_control_code
472: INTO l_eam_item_type,
473: l_serial_control_code
474: FROM mtl_system_items
475: WHERE inventory_item_id = p_instance_rec.inventory_item_id
476: AND organization_id = p_instance_rec.vld_organization_id;
477:
478: IF l_eam_item_type in (1, 3) AND l_serial_control_code <> 1 THEN

Line 989: FROM mtl_system_items

985: SELECT eam_item_type,
986: serial_number_control_code
987: INTO l_eam_item_type,
988: l_serial_control_code
989: FROM mtl_system_items
990: WHERE inventory_item_id = p_instance_rec.inventory_item_id
991: AND organization_id = p_instance_rec.vld_organization_id;
992:
993: IF l_eam_item_type in (1, 3) AND l_serial_control_code <> 1 THEN