APPS.EAM_ASSET_MOVE_UTIL dependencies on CSI_ITEM_INSTANCES

Line 307: l_subinv_code csi_item_instances.inv_subinventory_name%TYPE;

303: )
304: RETURN BOOLEAN
305: IS
306:
307: l_subinv_code csi_item_instances.inv_subinventory_name%TYPE;
308: --logging variables
309: l_api_name constant VARCHAR2(30) := 'hasSubInventory';
310: l_module VARCHAR2(200);
311: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

Line 332: FROM csi_item_instances

328: --Dbms_Output.put_line('Processing hasSubInventory');
329:
330: BEGIN
331: SELECT inv_subinventory_name into l_subinv_code
332: FROM csi_item_instances
333: WHERE instance_id = p_instance_id;
334:
335: EXCEPTION
336: WHEN NO_DATA_FOUND THEN

Line 388: from csi_item_instances WHERE

384:
385: BEGIN
386: select location_id
387: into l_location_id
388: from csi_item_instances WHERE
389: instance_id=P_instance_id;
390:
391: EXCEPTION
392: WHEN NO_DATA_FOUND THEN

Line 441: csi_item_instances cii

437: --Dbms_Output.put_line('Processing isInTransit');
438:
439: BEGIN
440: select msn.current_status into l_intransitFlag from mtl_serial_numbers msn,
441: csi_item_instances cii
442: WHERE cii.INSTANCE_id=p_instance_id
443: AND cii.INVENTORY_ITEM_ID = msn.INVENTORY_ITEM_ID
444: AND cii.SERIAL_NUMBER = msn.SERIAL_NUMBER ;
445: -- AND cii.INV_ORGANIZATION_ID = msn.CURRENT_ORGANIZATION_ID ;

Line 493: FROM csi_item_instances

489:
490: -- Dbms_Output.put_line('Processing isAssetRoute');
491: BEGIN
492: SELECT network_asset_flag INTO l_network_asset_flag
493: FROM csi_item_instances
494: WHERE instance_id = p_instance_id;
495:
496: EXCEPTION
497: WHEN NO_DATA_FOUND THEN

Line 544: SELECT EQUIPMENT_GEN_OBJECT_ID INTO l_EQUIPMENT_GEN_OBJECT_ID FROM csi_item_instances WHERE instance_id=p_instance_id;

540:
541: --Dbms_Output.put_line('Processing hasProdEquipLink');
542:
543: BEGIN
544: SELECT EQUIPMENT_GEN_OBJECT_ID INTO l_EQUIPMENT_GEN_OBJECT_ID FROM csi_item_instances WHERE instance_id=p_instance_id;
545:
546: --Dbms_Output.put_line(l_EQUIPMENT_GEN_OBJECT_ID);
547:
548: EXCEPTION

Line 602: FROM csi_item_instances

598: --Dbms_Output.put_line('Processing hasPropMngrLink');
599:
600: BEGIN
601: SELECT pn_location_id into l_location_id
602: FROM csi_item_instances
603: where instance_id=p_instance_id;
604:
605: EXCEPTION
606: WHEN NO_DATA_FOUND THEN

Line 660: from MTL_PARAMETERS mp,csi_item_instances cii

656:
657: --Dbms_Output.put_line('Processing isInMaintOrg');
658:
659: select mp.maint_organization_id into l_organization_id
660: from MTL_PARAMETERS mp,csi_item_instances cii
661: where mp.organization_id=cii.last_vld_organization_id
662: and cii.instance_id=p_instance_id ;
663:
664: --Dbms_Output.put_line('l_organization_id is'||l_organization_id);

Line 672: (SELECT serial_number FROM csi_item_instances WHERE instance_id = p_instance_id)

668: --selecting parent_object_id
669: /*
670: SELECT parent_object_id into l_parent_object_id FROM mtl_object_genealogy WHERE object_id =
671: (SELECT gen_object_id FROM mtl_serial_numbers WHERE serial_number =
672: (SELECT serial_number FROM csi_item_instances WHERE instance_id = p_instance_id)
673: )
674: AND parent_object_id IN (SELECT gen_object_id FROM mtl_serial_numbers)
675: AND START_DATE_ACTIVE<=SYSDATE
676: AND Nvl(end_DATE_ACTIVE,SYSDATE+1)>=sysdate ;

Line 700: from MTL_PARAMETERS mp,csi_item_instances cii, mtl_serial_numbers msn

696: RETURN TRUE;
697: ELSE
698: --Dbms_Output.put_line('searching l_parent_organization_id');
699: select mp.maint_organization_id into l_parent_organization_id
700: from MTL_PARAMETERS mp,csi_item_instances cii, mtl_serial_numbers msn
701: where mp.organization_id=cii.last_vld_organization_id
702: and cii.serial_number=msn.serial_number
703: and cii.INVENTORY_ITEM_ID = msn.INVENTORY_ITEM_ID
704: and cii.last_vld_organization_id = msn.CURRENT_ORGANIZATION_ID