DBA Data[Home] [Help]

APPS.EAM_ASSET_MOVE_UTIL dependencies on MTL_PARAMETERS

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 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