APPS.EAM_ASSET_MOVE_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 278

		select MTL_TRANSACTIONS_ENABLED_FLAG into l_flag from
		mtl_system_items_b where
		inventory_item_id = p_inventory_item_id
		and organization_id = p_organization_id;

Line: 285

      SELECT 'N' INTO  l_flag FROM dual;

Line: 331

		SELECT  inv_subinventory_name into l_subinv_code
		FROM    csi_item_instances
		WHERE   instance_id = p_instance_id;

Line: 386

select location_id
into l_location_id
from csi_item_instances  WHERE
instance_id=P_instance_id;

Line: 440

select msn.current_status into l_intransitFlag  from mtl_serial_numbers msn,
                                                 csi_item_instances cii
                                            WHERE cii.INSTANCE_id=p_instance_id
                                            AND cii.INVENTORY_ITEM_ID = msn.INVENTORY_ITEM_ID
                                            AND cii.SERIAL_NUMBER = msn.SERIAL_NUMBER ;

Line: 448

      SELECT 0 INTO  l_intransitFlag FROM dual;

Line: 492

		SELECT  network_asset_flag INTO l_network_asset_flag
		FROM    csi_item_instances
		WHERE   instance_id = p_instance_id;

Line: 498

      SELECT 'N' INTO  l_network_asset_flag FROM dual;

Line: 544

SELECT EQUIPMENT_GEN_OBJECT_ID INTO l_EQUIPMENT_GEN_OBJECT_ID FROM csi_item_instances WHERE instance_id=p_instance_id;

Line: 601

SELECT pn_location_id into l_location_id
FROM csi_item_instances
where instance_id=p_instance_id;

Line: 659

select mp.maint_organization_id  into l_organization_id
from MTL_PARAMETERS mp,csi_item_instances cii
where mp.organization_id=cii.last_vld_organization_id
and cii.instance_id=p_instance_id  ;

Line: 670

SELECT parent_object_id into l_parent_object_id FROM mtl_object_genealogy WHERE object_id =
(SELECT gen_object_id FROM mtl_serial_numbers WHERE serial_number =
(SELECT serial_number FROM csi_item_instances WHERE instance_id = p_instance_id)
)
AND parent_object_id IN (SELECT gen_object_id FROM mtl_serial_numbers)
AND    START_DATE_ACTIVE<=SYSDATE
AND Nvl(end_DATE_ACTIVE,SYSDATE+1)>=sysdate ;

Line: 679

SELECT parent_object_id into l_parent_object_id
FROM mtl_object_genealogy
WHERE object_id =p_gen_object_id
AND parent_object_id IN (SELECT gen_object_id FROM mtl_serial_numbers)
AND    START_DATE_ACTIVE<=SYSDATE
AND Nvl(end_DATE_ACTIVE,SYSDATE+1)>=sysdate ;

Line: 699

          select mp.maint_organization_id into l_parent_organization_id
          from MTL_PARAMETERS mp,csi_item_instances cii, mtl_serial_numbers msn
          where mp.organization_id=cii.last_vld_organization_id
          and cii.serial_number=msn.serial_number
	  and cii.INVENTORY_ITEM_ID = msn.INVENTORY_ITEM_ID
          and  cii.last_vld_organization_id = msn.CURRENT_ORGANIZATION_ID
          and msn.gen_object_id=l_parent_object_id ;

Line: 756

SELECT ORGANIZATION_ID
INTO l_org_assign_chk
FROM mtl_system_items_b
WHERE inventory_item_id =p_inventory_item_id
AND organization_id= p_organization_id;

Line: 764

      SELECT 'N' INTO  l_org_assign_chk FROM dual;