APPS.EAM_WORKORDERS_JSP dependencies on MTL_PARAMETERS

Line 1293: from csi_item_instances cii, mtl_system_items_b_kfv msikfv, mtl_parameters mp

1289: if(nvl(p_asset_number,l_asset_number_wl) is not null) then
1290: select nvl(cii.active_start_date, sysdate-1),
1291: nvl(cii.active_start_date, sysdate-1),msikfv.eam_item_type
1292: into l_start_date, l_end_date, l_eam_item_type
1293: from csi_item_instances cii, mtl_system_items_b_kfv msikfv, mtl_parameters mp
1294: where cii.inventory_item_id =msikfv.inventory_item_id
1295: and cii.last_vld_organization_id =msikfv.organization_id --Bug 2157979
1296: and cii.last_vld_organization_id = mp.organization_id
1297: and mp.maint_organization_id = p_organization_id

Line 1330: mtl_parameters mp, eam_org_maint_defaults eomd

1326: select cii.inventory_item_id , eomd.ACCOUNTING_CLASS_CODE,
1327: cii.instance_id, msikfv.eam_item_type , eomd.area_id
1328: into l_asset_group_id, l_asset_class, l_maintenance_object_id, l_eam_item_type , l_eam_location_id
1329: from csi_item_instances cii, mtl_system_items_b_kfv msikfv,
1330: mtl_parameters mp, eam_org_maint_defaults eomd
1331: where cii.inventory_item_id =msikfv.inventory_item_id
1332: and cii.last_vld_organization_id =msikfv.organization_id --Bug 2157979
1333: and cii.last_vld_organization_id = mp.organization_id
1334: and mp.maint_organization_id = p_organization_id

Line 1349: from mtl_system_items_b_kfv msikfv, mtl_parameters mp

1345: begin
1346: -- Changes by amondal for New Work Order API
1347: select msikfv.inventory_item_id, msikfv.eam_item_type, msikfv.serial_number_control_code
1348: into l_asset_group_id, l_eam_item_type, l_serial_number_control
1349: from mtl_system_items_b_kfv msikfv, mtl_parameters mp
1350: where msikfv.organization_id=mp.organization_id
1351: and mp.maint_organization_id = p_organization_id
1352: and msikfv.CONCATENATED_SEGMENTS = p_asset_group
1353: and rownum = 1;