203:
204: /* Bugfix 9003740: item_number should be used in place of segment1
205: SELECT segment1
206: INTO l_item_code
207: FROM mtl_item_flexfields
208: WHERE inventory_item_id=p_mtl_movement_transaction.inventory_item_id
209: AND organization_id=p_mtl_movement_transaction.organization_id;
210: */
211:
210: */
211:
212: SELECT item_number
213: INTO l_item_code
214: FROM mtl_item_flexfields
215: WHERE inventory_item_id=p_mtl_movement_transaction.inventory_item_id
216: AND organization_id=p_mtl_movement_transaction.organization_id;
217:
218:
222: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
223: THEN
224: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
225: , G_MODULE_NAME || l_procedure_name
226: , 'There is no data in item_number in mtl_item_flexfields for
227: item_id='||TO_CHAR(p_mtl_movement_transaction.inventory_item_id)
228: );
229: END IF;
230:
411:
412: /* Bugfix 9003740: item_number should be used in place of segment1
413: SELECT segment1
414: INTO l_item_code
415: FROM mtl_item_flexfields
416: WHERE inventory_item_id=p_mtl_movement_transaction.inventory_item_id
417: AND organization_id=p_mtl_movement_transaction.organization_id;
418: */
419:
418: */
419:
420: SELECT item_number
421: INTO l_item_code
422: FROM mtl_item_flexfields
423: WHERE inventory_item_id=p_mtl_movement_transaction.inventory_item_id
424: AND organization_id=p_mtl_movement_transaction.organization_id;
425:
426:
430: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
431: THEN
432: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
433: , G_MODULE_NAME || l_procedure_name
434: , 'There is no data in item_number in mtl_item_flexfields for
435: item_id='||TO_CHAR(p_mtl_movement_transaction.inventory_item_id)
436: );
437: END IF;
438: