DBA Data[Home] [Help]

APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 2156: select MTL.concatenated_segments,csi.serial_number from csi_item_instances csi, mtl_system_items_kfv MTL

2152:
2153: l_debug_key CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name;
2154:
2155: CURSOR item_info_csr(p_instance_number IN VARCHAR2) IS
2156: select MTL.concatenated_segments,csi.serial_number from csi_item_instances csi, mtl_system_items_kfv MTL
2157: where csi.instance_number like p_instance_number
2158: and csi.inventory_item_id = MTL.inventory_item_id
2159: and CSI.INV_MASTER_ORGANIZATION_ID = MTL.ORGANIZATION_ID;
2160: